From: | Ken Johanson <pg-user(at)kensystem(dot)com> |
---|---|
To: | Kris Jurka <books(at)ejurka(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: RETURNING clause: how to specifiy column indexes? |
Date: | 2007-12-14 04:14:51 |
Message-ID: | 4762033B.9080004@kensystem.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
Kris Jurka wrote:
>
> Using pg_catalog tables is better than using information_schema because
> of the way permissions work. For information_schema you must be the
> table owner, while people who only have permissions to access a table
> will most likely be able to read pg_catalog.
>
Do you have an equivalent query/join handy that will get the catalog and
schema and table and column names frm the pg tables?
SELECT column_name
FROM information_schema.columns
WHERE table_catalog=? AND table_schema=? AND table_name=?
ORDER BY ordinal_position
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2007-12-14 04:54:01 | Re: Need to find out which process is hitting hda |
Previous Message | Ow Mun Heng | 2007-12-14 03:13:40 | HouseKeeping and vacuum Questions |
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Magoffin | 2007-12-14 06:38:54 | Re: how to set a PreparedStatement column of XML type in 8.3? |
Previous Message | Kris Jurka | 2007-12-14 02:08:38 | Re: RETURNING clause: how to specifiy column indexes? |