Postgres Pro
Downloads
Home   >   mailing lists

Postgresql database access - Mailing list pgsql-sql

From Marcos Aurélio S. da Silva
Subject Postgresql database access
Date
Msg-id 3A561322.37AEE495@cpatc.embrapa.br
Whole thread Raw
Responses Re: Postgresql database access  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: pqReadData()
Next
From: "Oliver Elphick"
Date:
Subject: Re: Postgresql database access