From: | Dmitry Tkach <dmitry(at)openratings(dot)com> |
---|---|
To: | sowbug <brian(dot)harris(at)optdatainc(dot)com> |
Subject: | Re: newbie question |
Date: | 2003-03-17 16:44:46 |
Message-ID: | 3E75FB7E.7000005@openratings.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Lebedev | 2003-03-17 16:54:12 | Change column type |
Previous Message | Bruce Momjian | 2003-03-17 16:37:33 | Re: Feature request for postgresSQL |