Re: Read an already existing DB: functions & triggers.

Started by T.J.Farrellalmost 26 years ago2 messagesgeneral
Jump to latest
#1T.J.Farrell
T.J.Farrell@wanadoo.fr

Hi,

I am dealing with an already built database from which there is no
documentation available on how it was designed. I can list indices, tables,
and sequences from the DB using the '\d' command. But how can I list
functions, triggers, and other implementations?

Thank in advance for your reply.

#2Bryan White
bryan@arcamax.com
In reply to: T.J.Farrell (#1)

I am dealing with an already built database from which there is no
documentation available on how it was designed. I can list indices,

tables,

and sequences from the DB using the '\d' command. But how can I list
functions, triggers, and other implementations?

try:
pg_dump -s dbname

That will write all the statements needed to recreate the database to
stdout. The -s option tells it to omit the actual data dumps.