Postgresql database access

From: "Marcos Aurélio S(dot) da Silva" <aurelio(at)cpatc(dot)embrapa(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: Postgresql database access
Date: 2001-01-05 18:32:02
Message-ID: 3A561322.37AEE495@cpatc.embrapa.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear Pg experts,

I have two databases and i want to refer to one table in a database "X"
when
i'm using database "Y". Something like this:

select * from X.table

This causes a parse error. What's the correct sintax?

Best regards,

Marcos Aurelio
Brazil

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-01-05 18:42:38 Re: [SQL] Casting
Previous Message Richard Huxton 2001-01-05 18:09:33 Re: Non-procedural field merging?