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

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Read an already existing DB: functions & triggers.
Date: 2000-06-19 12:56:46
Message-ID: 00f801bfd9ed$d3be3dc0$2dd260d1@arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2000-06-19 12:58:26 Re: aggregate functions
Previous Message John Brothers 2000-06-19 12:09:42 Re: Backend died while dropping index