Re: Viewing Database Scheme - Mailing list pgsql-general

From Doug McNaught
Subject Re: Viewing Database Scheme
Date
Msg-id 87vew4b49b.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Viewing Database Scheme  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Viewing Database Scheme
List pgsql-general
Rich Shepard <rshepard@appl-ecosys.com> writes:

>    When installing the application I specified the database name as 'contacts'
> (not very innovative or clever, but descriptive). When I open the database
> with 'psql contacts' and ask to have the tables dumped (with \d), they go
> streaming by on the display. Of course, the bash 'tee' or 'less' commands
> don't work to allow me to capture the stream to a file or page through the
> output.

You can either use 'pg_dump --schema-only' as another poster
suggested, or use the '\o' command in psql.

-Doug

pgsql-general by date:

Previous
From: Ezra Taylor
Date:
Subject: Re: Viewing Database Scheme
Next
From: Tom Lane
Date:
Subject: Re: Seeking a better PL/pgSQL editor-debugger