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

Re: FW: tablename.columnname support

From: Haroldo Stenger <hstenger(at)adinet(dot)com(dot)uy>
To: vijayendra(dot)agrawal(at)wipro(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: FW: tablename.columnname support
Date: 2000-09-17 17:16:29
Message-ID: 39C4FC6D.ADD2C997@adinet.com.uy (view raw or flat)
Thread:
Lists: 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(at)ieee(dot)org
 Montevideo, Uruguay. | hstenger(at)adinet(dot)com(dot)uy
----------------------+------------------------
 Visit UYLUG Web Site: http://www.linux.org.uy
-----------------------------------------------

In response to

Responses

pgsql-admin by date

Next:From: Dronamraju RajeshDate: 2000-09-18 07:53:58
Subject: shmget fails for min buffers of postmaster also on solaris 7 .....
Previous:From: Peter EisentrautDate: 2000-09-17 13:02:57
Subject: Re: libpq errors when makeing postgres 7.0.2...

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