Re: Viewing Database Scheme

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Viewing Database Scheme
Дата
Msg-id 87vew4b49b.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Viewing Database Scheme  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Viewing Database Scheme  (Rich Shepard <rshepard@appl-ecosys.com>)
Список 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 по дате отправления:

Предыдущее
От: Ezra Taylor
Дата:
Сообщение: Re: Viewing Database Scheme
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Seeking a better PL/pgSQL editor-debugger