Re: RETURNING clause: how to specifiy column indexes?

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 00:48:31
Message-ID: 4761D2DF.4080204@kensystem.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Kris and all,

Here is the query I will call to the get the name of columns by ordinal
position. Do you see any compatibility drivers will older server
versions, or other issues?

SELECT column_name
FROM information_schema.columns
WHERE table_catalog=? AND table_schema=? AND table_name=?
ORDER BY ordinal_position

Ken

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-12-14 01:08:50 Re: plpgsql trigger coredumps instance
Previous Message Tom Lane 2007-12-14 00:37:39 Re: [GENERAL] Slow PITR restore

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2007-12-14 01:03:21 Re: Slow query after upgrades
Previous Message Guillaume Smet 2007-12-14 00:27:23 Re: Slow query after upgrades