I am trying to find out some information on how to set up a cross database links so that I can have queries and foreign keys that cross a physical database. This is not just a technical requirement, but a legal one (The client requires that we do not co-mingle data). I have a new database that has tables and indices named using a new naming schema, and an old database that was implemented based on a customer requirement that is ugly, and I don't really want to put everything into one database (technical reason). I have read that contrib/dblink can do this, but I am unable to find any documentation for this features, or infact any documentation on what is in the 'contrib' pacakge. Can anyone point me to a good place to find contrib docs, or and point me to database cross linking stuff. My boss will be really pissed if I tell him we need to spend $10k to implement Oracle to have a good solution ;)
Thanks, Alex Turner NetEconomist ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org