Re: Viewing Database Scheme

Поиск
Список
Период
Сортировка
От Ezra Taylor
Тема Re: Viewing Database Scheme
Дата
Msg-id eb90f15e0601281019m41c6e804wea0c3b38436cb6d7@mail.gmail.com
обсуждение исходный текст
Ответ на Viewing Database Scheme  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Viewing Database Scheme  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
Can you use redirection.

On 1/28/06, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>   I'm trying to help the XRMS developers add postgres support ('cause that's
> what I use). They've done well so far with help from other postgres users,
> but now I've been asked to help getting the indices correct.
>
>   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.
>
>   I've looked in the 8.1 pdf manual and the Douglas*2 book without spotting
> the command I need to get a list of all tables and their fields. When I've
> developed postgres applications I know the schema so this has not been an
> issue before.
>
>   Please pass me a clue stick on how to view all the tables in this
> application.
>
> TIA,
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.               |   Author of "Quantifying Environmental
> Applied Ecosystem Services, Inc. (TM)   |  Impact Assessments Using Fuzzy Logic"
> <http://www.appl-ecosys.com>     Voice: 503-667-4517         Fax: 503-667-8863
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


--
Ezra Taylor

В списке pgsql-general по дате отправления:

Предыдущее
От: "Jim Buttafuoco"
Дата:
Сообщение: Re: Viewing Database Scheme
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Viewing Database Scheme