On Mon, 22 Sep 2008 16:06:06 -0600 kevin kempter <[EMAIL PROTECTED]> wrote:
> Hi List; > > 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'); SELECT column_name FROM information_schema.columns WHERE table_name = 'table'; Joshua D. Drake > > Any thoughts ? > > Thanks in advance... > > > -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
