On Jan 10, 2008 1:37 AM, Ken Johanson <pg-user(at)kensystem(dot)com> wrote:
> Hi all,
>
> I am looking for expertise on how to program the equivalent to this
> query, but using the pg_catalog tables, which I understand have fewer
> security restrictions than information_schema in some cases:
>
> SELECT column_name
> FROM information_schema.columns
> WHERE table_catalog=? AND table_schema=? AND table_name=?
> ORDER BY ordinal_position
Do what psql does...launch it with psql -E, and it will echo any
internal queries it makes back to you. Do \d on a couple of tables
and you should see what is going on.
merlin