database select support

From: "Michal Klacan" <michal_klacan(at)computel(dot)sk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: database select support
Date: 1999-06-16 11:13:18
Message-ID: 002001beb7e9$3d26d290$92641cc3@CMMCHK
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)aaaa(dot)a1

this is no work ?

Pleace help me. How I may write this select.

Thanx.
Michal Klacan

Browse pgsql-sql by date

  From Date Subject
Next Message Herouth Maoz 1999-06-16 11:25:06 Re: [SQL] converting from number to text
Previous Message Jan Wieck 1999-06-16 10:55:37 Re: [SQL] example of trigger to track DB changes