Received: from beiramar.cpatc.embrapa.br (beiramar.cpatc.embrapa.br [200.202.141.1]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f05JWY728790 for ; Fri, 5 Jan 2001 14:32:34 -0500 (EST) (envelope-from aurelio@cpatc.embrapa.br) Received: from cpatc.embrapa.br (aurelio.cpatc.embrapa.br [200.202.141.11]) by beiramar.cpatc.embrapa.br (8.9.3/8.9.3) with ESMTP id QAA20862 for ; Fri, 5 Jan 2001 16:32:05 -0300 (EST) Message-ID: <3A561322.37AEE495@cpatc.embrapa.br> Date: Fri, 05 Jan 2001 16:32:02 -0200 From: "Marcos =?iso-8859-1?Q?Aur=E9lio?= S. da Silva" X-Mailer: Mozilla 4.7 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Postgresql database access References: <3A4C786E.237AC34B@cpatc.embrapa.br> <3A4C92BE.E6DB1156@flex.ro> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/68 X-Sequence-Number: 729 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