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

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.