Re: Help with creating Documentation - Mailing list pgsql-novice

From joseph speigle
Subject Re: Help with creating Documentation
Date
Msg-id 20070309010612.GB9460@www.sirfsup.com
Whole thread Raw
In response to Help with creating Documentation  (WejofOST@aol.com)
List pgsql-novice
>
> How can I generate a list of tables and then fields within the tables in
> pgsql?
>

log into psql on the commandline.
the command you want is

\dt

will show all tables


\d table_name

will show you fields


http://www.sirfsup.com/sql_servers/postgresql/pg_utilities.htm#psql


--
joe speigle
http://combali.co.kr

pgsql-novice by date:

Previous
From: "Michael Swierczek"
Date:
Subject: Re: Runaway Instances of Postmaster
Next
From: joseph speigle
Date:
Subject: Re: Runaway Instances of Postmaster