You cannot do that in postgres - it can only see tables in the database you are currently connected to.
7.3 has notion of schema though - that lets you have tables with the same names in the same database, but different
'schemas'.
I hope, it helps..
Dima
sowbug wrote:
> I have been using mysql, but am switching to postgres. Can someone
> tell me the proper syntax for associating a table with a particular
> database. In mysql the syntax is databasename.table name, but have
> found out this doesn't work in postgres. I have tables with the same
> names, but in different databases and need to specify which database
> to use within my sql. e.g:
> Mysql: select * from db.table;
> Pgsql: select * from db.table;//doesn't work!!
>
> What's the proper syntax??
>
> regards,
> Brian
