Re: FW: tablename.columnname support

Поиск
Список
Период
Сортировка
От Haroldo Stenger
Тема Re: FW: tablename.columnname support
Дата
Msg-id 39C4FC6D.ADD2C997@adinet.com.uy
обсуждение исходный текст
Ответ на FW: tablename.columnname support  ("vijayendra mohan agrawal" <vijayendra.agrawal@wipro.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: libpq errors when makeing postgres 7.0.2...
Следующее
От: Dronamraju Rajesh
Дата:
Сообщение: shmget fails for min buffers of postmaster also on solaris 7 .....