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.
How to access a table from another database in PostGreSQL
Moderator: General Moderators