Re: [GENERAL] newbie question... how do I get table structure?

[Aaron Bratcher]

Is there no way I can do it with a standard select command in a 
different client? I don't need the indexes, just the column 
names/types.
--
Aaron Bratcher
ab DataTools
http://www.abDataTools.com

On Feb 6, 2004, at 8:12 AM, Harald Fuchs wrote:

In article <[EMAIL PROTECTED]>,
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
Aaron Bratcher wrote:
What command can I use to get the structure of a given table?



If psql is client

\d tablename
Without psql you can use

  pg_dump -s DBNAME -t TBLNAME

from your shell prompt.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings