[nzlug] PHP/Postgres question

Robert Coup robert.coup at onetrackmind.co.nz
Fri May 25 20:30:06 NZST 2007


anru chen wrote:
> you can query against postgres's meta data table, like pg_attribute.
Easier way:

SELECT * FROM information_schema.columns WHERE table_name = 'my_table';

Rob :)

-- 
One Track Mind Ltd.
PO Box 1604, Shortland St, Auckland, New Zealand
Phone +64-9-966 0433 Mobile +64-21-572 632
Web http://www.onetrackmind.co.nz 





More information about the NZLUG mailing list