Re: RETURNING clause: how to specifiy column indexes?

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