Re: [GENERAL] list fieldnames in table? (from PHP)

2004-10-30 Thread GreyGeek
Miles Keaton wrote: Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? ---(end of broadcast)--- TIP 3: if posting/reading

Re: [GENERAL] list fieldnames in table? (from PHP)

2004-10-26 Thread Justin Wyer
Miles Keaton wrote: Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet,

Re: [GENERAL] list fieldnames in table? (from PHP)

2004-10-26 Thread Scott Marlowe
On Mon, 2004-10-25 at 20:36, Miles Keaton wrote: Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? In addition to the other ideas given here, you also have the SQL spec standard

Re: [GENERAL] list fieldnames in table? (from PHP)

2004-10-26 Thread Joshua D. Drake
Scott Marlowe wrote: On Mon, 2004-10-25 at 20:36, Miles Keaton wrote: Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? Hello, This PHP function will give you

[GENERAL] list fieldnames in table? (from PHP)

2004-10-25 Thread Miles Keaton
Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

Re: [GENERAL] list fieldnames in table? (from PHP)

2004-10-25 Thread Steven Klassen
* Miles Keaton [EMAIL PROTECTED] [2004-10-25 19:36:43 -0700]: Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? If your namespace is 'public' and your table is 'users', for

Re: [GENERAL] list fieldnames in table? (from PHP)

2004-10-25 Thread Michael Fuhr
On Mon, Oct 25, 2004 at 07:36:43PM -0700, Miles Keaton wrote: Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename If you run psql -E or type \set ECHO_HIDDEN after you're in psql then you'll see the hidden queries that psql sends for