Re: FW: tablename.columnname support - Mailing list pgsql-admin

From Haroldo Stenger
Subject Re: FW: tablename.columnname support
Date
Msg-id 39C4FC6D.ADD2C997@adinet.com.uy
Whole thread Raw
In response to FW: tablename.columnname support  ("vijayendra mohan agrawal" <vijayendra.agrawal@wipro.com>)
List pgsql-admin
vijayendra mohan agrawal wrote:
> The design in my module is such that for any requests from the client side,
> I have to do some DB operation. The operation could be either SELECT,
> UPDATE, INSERT or DELETE in the database depending on the request id and the
> data in the database. So, I am having a meta-data table in the database,
> which will tell me what kind of operation to do on a particular request id,
> what are the tables involved, what are the columns involved, what are the
> keys for these tables, and what are the relations(join conditions) between
> the tables involved. So, here in column names, I am storing columns in the
> tablename.columnname format, becuase columns can be from many tables.

I see your point. But couldn't you just strip out the dbname prefix when talking
to PostgreSQL?

Best Regards,
Haroldo.


--
----------------------+------------------------
 Haroldo Stenger      | hstenger@ieee.org
 Montevideo, Uruguay. | hstenger@adinet.com.uy
----------------------+------------------------
 Visit UYLUG Web Site: http://www.linux.org.uy
-----------------------------------------------

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: libpq errors when makeing postgres 7.0.2...
Next
From: Dronamraju Rajesh
Date:
Subject: shmget fails for min buffers of postmaster also on solaris 7 .....