From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Ligia Pimentel <lmpimentel(at)yahoo(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Selecting data from a table created in another database... |
Date: | 2002-07-03 20:22:04 |
Message-ID: | 200207032022.g63KM4A02548@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Ligia Pimentel wrote:
> I don't know if this can be done...
>
> In MSSQL Server I can access a table created in another database (on the
> same server, of course) by using the following syntaxis...
>
> select * from databasename..tablename where condition;
>
> Can I do this in postgres?
>
> I'm using version 7.2 on a redhat server...
Sorry, you can't do cross-db queries with PostgreSQL. Take a look at
/contrib/dblink as an option.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Frazer | 2002-07-03 20:59:03 | Possible Bug regarding temp tables (sql or psql?) |
Previous Message | Jie Liang | 2002-07-03 19:03:27 | Re: pg_restore cannot restore function |