How to access a table from another database in PostGreSQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
solaivel
Forum Newbie
Posts: 1
Joined: Tue Jul 02, 2002 1:29 am

How to access a table from another database in PostGreSQL

Post by solaivel »

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.
Post Reply