Re: HOWTO: Get a table or database definition

From: googlemike(at)hotpop(dot)com (Google Mike)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: HOWTO: Get a table or database definition
Date: 2004-09-05 11:20:43
Message-ID: 25d8d6a8.0409050320.5062ceba@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One other option, which I had forgotten for a long time, was:

\d <object name>

...which can describe many things, although this doesn't give you the
CREATE syntax like a pg_dump can do. Please also note that a pg_dump
can dump output to the screen if you don't specify a file, so if
you're only outputting the schema with "-s -C", it doesn't really
impact a live production database much at all.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2004-09-05 12:11:55 hebrew with MS Access Front End
Previous Message Peter Eisentraut 2004-09-05 06:50:00 Re: readline selection (was Re: [GENERAL] psql leaking? - SOLVED)