Re: Read an already existing DB: functions & triggers. - Mailing list pgsql-general

From Bryan White
Subject Re: Read an already existing DB: functions & triggers.
Date
Msg-id 00f801bfd9ed$d3be3dc0$2dd260d1@arcamax.com
Whole thread Raw
In response to Re: Read an already existing DB: functions & triggers.  ("T.J.Farrell" <T.J.Farrell@wanadoo.fr>)
List pgsql-general
> 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.


pgsql-general by date:

Previous
From: Holger Klawitter
Date:
Subject: Re: aggregate functions
Next
From: Alex Pilosov
Date:
Subject: Re: aggregate functions