| From: | "Steve SAUTETNER" <ssa(at)informactis(dot)com> | 
|---|---|
| To: | "Pgsql-General" <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Reading a table in a database from another database | 
| Date: | 2001-08-13 07:45:09 | 
| Message-ID: | BKEHJDOFOAHJBCOBCHJGEEBDCDAA.ssa@informactis.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hello !
I did exposed my problem, but i didn't expose it correctly :
I have 2 databases, here is the script :
\c template1
create database users;
\c users
create table users_info
	(
		id int4 primary key,
		name varchar(30),
		...
	);
\c template1
create database products;
\c products
create table products_info
	(
		id int4 primary key,
		id_owner int4,
		lib varchar(30),
		unitprice numeric(13,2),
		...
	);
I must define, in the database products, the products_info.id_owner
attribute as a foreign key of the attribute users_info.id in the database
users.
I can't merge the 2 databases. (These are very big, and much tables have the
same name).
Thanks for your help.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomáš Kubiš | 2001-08-13 08:07:29 | posix_getpwnam | 
| Previous Message | Mathew Frank | 2001-08-13 07:12:20 | RE: Re: Bug#108286: case sensitivity in column names |