Is the following select sufficient and correct for extracting the column
names of a table, excluding all system columns?
select attname from pg_attribute
where attrelid=
(select relfilenode from pg_class
where relname like <insert table name here>)
and attnum > 0
I want to be certain that no system columns are returned, only columns I've
created.
Am I overlooking anything?
Thanks!
Tim Barnard
S.E. Mgr
Hartford Communications Corporation