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(dot)6090205(at)commandprompt(dot)com>,
> "Joshua D. Drake" <jd(at)commandprompt(dot)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.