Re: [SQL] Postgresql database access

2001-01-05 Thread Oliver Elphick
"Marcos =?iso-8859-1?Q?Aur=E9lio?= S. da Silva" wrote: >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 erro

[SQL] Postgresql database access

2001-01-05 Thread 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