Postgres Pro
Downloads
Home   >   mailing lists

Thread: database select support

database select support

From
"Michal Klacan"
Date:
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