[SQL] Postgresql database access

[Marcos Aurélio S. da Silva]

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