How to access a table from another database in PostGreSQL
Posted: Tue Jul 02, 2002 1:29 am
How to retrive the details of a table which is lying in one database, i am executing the select query in another database from the same server.
what is the syntax for mentioning the database name and table name.
Is MSSQL we can access like [dbname].[owner].[tablename].
similary how can i acces the table in postgresql database.
what is the syntax for mentioning the database name and table name.
Is MSSQL we can access like [dbname].[owner].[tablename].
similary how can i acces the table in postgresql database.