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

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 <4022FB80.6090205@commandprompt.com>,
> "Joshua D. Drake" <jd@commandprompt.com> 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.