Re: [GENERAL] table column information

2004-05-17 Thread Nick Barr
Scot L. Harris wrote: Currently using Postgresql 7.2.4-5.80 with php 4.2.2.-8.0.8 on a redhat 8.0 system. I am writing some php scripts where I want to generate a list of the column names in a particular table that the user selects. I could take the brute force method and hard code the column

[GENERAL] table column information

2004-05-16 Thread Scot L. Harris
Currently using Postgresql 7.2.4-5.80 with php 4.2.2.-8.0.8 on a redhat 8.0 system. I am writing some php scripts where I want to generate a list of the column names in a particular table that the user selects. I could take the brute force method and hard code the column names but then every

Re: [GENERAL] table column information

2004-05-16 Thread Carl E. McMillin
To: [EMAIL PROTECTED] Subject: [GENERAL] table column information Currently using Postgresql 7.2.4-5.80 with php 4.2.2.-8.0.8 on a redhat 8.0 system. I am writing some php scripts where I want to generate a list of the column names in a particular table that the user selects. I could take

Re: [GENERAL] table column information

2004-05-16 Thread Scot L. Harris
On Sun, 2004-05-16 at 16:58, Carl E. McMillin wrote: Hi, Use getMetadata of java.sql.Connection. According to jdocs, the DatabaseMetaData object can probably give you what you are looking for. Carl |};-) Thanks, but I am using php 4.2.2 not java for this application. -- Scot