Re: Selecting data from a table created in another database...

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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026