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