Hi<div>Postgres doesn't properly support cross-database queries but there seems to something called dblink</div><div><br></div><div>I'm looking at constructing a database which will have a point data (customer locations, delivery records and other logistics info) but all the other data is open-source feature data - boundaries, roads, etc.</div>
<div><br></div><div>I had hoped to implement a structure witgh the feature data in one database and put my application-specific data in another - not least because it simplifies backups and so on. The feature data is very large and slow-to-change whereas the logistics data is much smaller and more dynamic.</div>
<div><br></div><div>Is this a practical approach for postgis type queries or do I have to put it all in one database to get good querying flexibility?</div><div><br></div><div>Thanks</div><div>Tim</div><div><br></div>