Skip site navigation (1) Skip section navigation (2)

qualified column names

From: Dave Cramer <dave(at)fastcrypt(dot)com>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: qualified column names
Date: 2003-04-15 13:40:12
Message-ID: 1050414011.30093.411.camel@inspiron.cramers (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-interfacespgsql-jdbc
jdbc and I suspect odbc have a requirement to return the table, and
schema of a column in a result set.

for jdbc at least a possible solution is to return

schema.table.column for each column returned. This could be turned
off/on using  GUC variable.

functions, and computed fields can just return the column name as they
don't belong to a schema or table.

Does anyone have any other requirments?
-- 
Dave Cramer <dave(at)fastcrypt(dot)com>
Cramer Consulting


In response to

pgsql-hackers by date

Next:From: Dave CramerDate: 2003-04-15 13:40:29
Subject: qualified column names
Previous:From: Dave CramerDate: 2003-04-15 13:38:46
Subject: qualified column names

pgsql-general by date

Next:From: Dave CramerDate: 2003-04-15 13:40:29
Subject: qualified column names
Previous:From: Dave CramerDate: 2003-04-15 13:38:46
Subject: qualified column names

pgsql-interfaces by date

Next:From: Dave CramerDate: 2003-04-15 13:40:29
Subject: qualified column names
Previous:From: Dave CramerDate: 2003-04-15 13:38:46
Subject: qualified column names

pgsql-jdbc by date

Next:From: Dave CramerDate: 2003-04-15 13:40:29
Subject: qualified column names
Previous:From: Dave CramerDate: 2003-04-15 13:38:46
Subject: qualified column names

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group