On Jan 10, 2008 1:37 AM, Ken Johanson <pg-user@xxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
