Here is the sql statement with the trailing semicolon I'm testing with--substitute a valid table name for the word 'my_table' below:
SELECT pg_attribute.attname, pg_attribute.attnotnull, pg_attribute.atttypmod, pg_type.typname FROM pg_attribute JOIN pg_class ON pg_attribute.attrelid = pg_class.oid JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace JOIN pg_type on pg_type.oid = pg_attribute.atttypid where pg_namespace.nspname = 'public' AND pg_class.relname = 'my_table' and pg_class.relkind = 'r' and pg_attribute.attnum > 0 ORDER BY pg_attribute.attnum;
Thanks...jack -- ******************************************** Who: L Jack Wilson Where: ljwilson@dNiOgSiPtAaMlav.com How: Remove Capital Letters from above for a valid email address Why: Standard Disclaimer fits nicely here.