[SQL]

Hi Team, I am using PostgreSQL 9.2.3 in Windows platform. I have created two databases in it. Now I want to refer the tables across the databases. Meaning would like to create Database link. Can anyone guide me on how to create a DB link?   Thanks and Regards Kaleeswaran Velu

Re: [SQL]

1 - why two databases? Couldn't you have just created two separate SCHEMAS? 2 - if you insist on two separate databases: http://www.postgresql.org/docs/9.2/static/dblink.html From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Kaleeswaran Velu Sent: Tues

Re: [SQL]

Kaleeswaran Velu wrote: > Hi Team, > I am using PostgreSQL 9.2.3 in Windows platform. I have created two databases > in it. Now I want to refer the tables across the databases. Meaning would like > to create Database link. Can anyone guide me on how to create a DB link? You can use db_link, see

[SQL] Many to many link tables with history?

Hi folks, I'm new here. I hope this is the correct list While creating a database of customer subscribed services with DNS domains, I want to: *) enable customers to subscribe to multiple services *) each service can have multiple domain names per customer *) a domain name must be unique per