I want to pull the list of column names from the system catalogs for a
specified table. I only want column names, I want to exclude any index
names, or other non-column name rows. I got this far (see below)
however this query produces additional rows with attname's like
tableoid, cmax, xmax ctid, etc.
select attname from pg_attribute where attrelid = (select oid from
pg_class where relname = 'my_tablename');
Any thoughts ?
Thanks in advance...
pgsql-admin by date
|Next:||From: Joshua Drake||Date: 2008-09-22 22:29:50|
|Subject: Re: Select all table column names for a specified tablename
(per the system catalogs)|
|Previous:||From: Tena Sakai||Date: 2008-09-22 18:40:28|
|Subject: Re: question on pg_ctl|