try something like this: select attname from pg_class, pg_attribute where relname='your_tablename' and attrelid=relfilenode;
-- Mit freundlichem Gruß Henrik Steffen Geschäftsführer top concepts Internetmarketing GmbH Am Steinkamp 7 - D-21684 Stade - Germany -------------------------------------------------------- http://www.topconcepts.com Tel. +49 4141 991230 mail: [EMAIL PROTECTED] Fax. +49 4141 991233 -------------------------------------------------------- Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de System-Partner gesucht: http://www.franchise.city-map.de -------------------------------------------------------- Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563 -------------------------------------------------------- > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von > Aaron Bratcher > Gesendet: Freitag, 6. Februar 2004 15:10 > An: [EMAIL PROTECTED] > Betreff: Re: [GENERAL] 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 <[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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
