Re: Read an already existing DB: functions & triggers.
Started by T.J.Farrellalmost 26 years ago2 messagesgeneral
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.
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.