logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Re: Table description: msg#00031

Subject: Re: Table description
Lì martedì, 2004/04/27 alle 13:21, +0000, Phillip Neumann ha scritto:
> Hello..
> 
> 
> im trying to make a gui for the tables of my database. So, i have to
> know what is the column names of the table i will work, so i can add a
> nice title for each column in the gui , and then display the data.
> How would i do this?
> is there something like \d table?

curs.execute("SELECT * FROM table WHERE 1=0")

then look at curs.description.

hope this helps,
federico

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                
fog-8fiUuRrzOP0dnm+yROfE0A@xxxxxxxxxxxxxxxx
INIT.D Developer                                           
fog-NGVKUo/i/6DYtjvyW6yDsg@xxxxxxxxxxxxxxxx
  We are all dust, Saqi, so play the lute
                    We are all wind, Saqi, so bring wine. -- Omar Khayam

Attachment: signature.asc
Description: Questa parte del messaggio =?ISO-8859-1?Q?=E8?= firmata

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg
<Prev in Thread] Current Thread [Next in Thread>