pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dave Cramer <Dave@micro-automation.net>
To: pgsql-jdbc@postgresql.org <pgsql-jdbc@postgresql.org>
Subject: qualified column names
Date: 15 Apr 2003 09:40:29 -0400
Message-ID: <1050414029.1790.414.camel@inspiron.cramers> (raw)
In-Reply-To: <Pine.LNX.4.44.0304151046520.1750-100000@peter.localdomain>
References: <Pine.LNX.4.44.0304151046520.1750-100000@peter.localdomain>

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@fastcrypt.com>
Cramer Consulting
-- 
Dave Cramer <Dave@micro-automation.net>




view thread (4+ messages)  latest in thread

Message-ID: <1050414029.1790.414.camel@inspiron.cramers>
Permalink:  ../1050414029.1790.414.camel@inspiron.cramers/
Also on:    postgresql.org/message-id/1050414029.1790.414.camel@inspiron.cramers

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: Dave@micro-automation.net, pgsql-jdbc@postgresql.org
  Subject: Re: qualified column names
  In-Reply-To: <1050414029.1790.414.camel@inspiron.cramers>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox