From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Afton & Ray Still <rastill(at)shaw(dot)ca> |
Cc: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: find column names from query |
Date: | 2005-01-24 08:42:41 |
Message-ID: | 20050124084241.GA40343@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sun, Jan 23, 2005 at 11:46:15PM -0700, Afton & Ray Still wrote:
> going through the documentation I found the following:
>
> SELECT attname::regclass FROM pg_attribute WHERE attrelid = travel::regclass
Are you sure the example looked like that? attname is a name type
and shouldn't be cast to regclass, and "travel" should be in single
quotes if it's a table name. Try this:
SELECT attname FROM pg_attribute WHERE attrelid = 'travel'::regclass;
Here's something a little more useful:
SELECT attname
FROM pg_attribute
WHERE attrelid = 'travel'::regclass
AND attisdropped IS FALSE
AND attnum >= 1
ORDER BY attnum;
If you're using PostgreSQL 7.4 or later then you could also use the
Information Schema; see the documentation for details.
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'travel'
ORDER BY ordinal_position;
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | Tjibbe Rijpma | 2005-01-24 08:55:13 | Re: find column names from query |
Previous Message | Afton & Ray Still | 2005-01-24 06:46:15 | find column names from query |