Postgres Pro
Downloads
Home   >   mailing lists

database select support - Mailing list pgsql-sql

From Michal Klacan
Subject database select support
Date
Msg-id 002001beb7e9$3d26d290$92641cc3@CMMCHK
Whole thread Raw
List pgsql-sql
Tree view
Hi
 
I have following problem:
 
I have two databases.
First is 'aaaa' and second is 'bbbb'
In databse 'aaaa' I have table 'a1'.
 
I want connect to database 'bbbb' and select values from table a1 in
database 'aaaa'.
 
If I write
 
    select * from localhost@aaaa.a1
 
this is no work ?
 
Pleace help me. How I may write this select.
 
Thanx.
Michal Klacan
 

pgsql-sql by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] example of trigger to track DB changes
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] converting from number to text