Re: Help with creating Documentation

From: joseph speigle <joesp(at)sirfsup(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Help with creating Documentation
Date: 2007-03-09 01:06:12
Message-ID: 20070309010612.GB9460@www.sirfsup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message joseph speigle 2007-03-09 01:52:18 Re: Runaway Instances of Postmaster
Previous Message Michael Swierczek 2007-03-09 01:03:10 Re: Runaway Instances of Postmaster