Are there any tools available that would allow me to import the whole world into a Postgres database and then export sections as required as a .sql file?
I want to set up a fairly powerful ‘server’ that will hold all the data and then export smaller sections to be imported unto a 32-bit Postgres database for use with a mobile application. The mobile device does no have the power/memory to import directly. I believe that using .sql is the only way of converting between 64-bit postgres (on the server) and 32-bit postgres on the mobile device but I stand to be corrected.
Andrew