On 1/13/2011 7:02 AM, Jaiswal Dhaval Sudhirkumar wrote:
Hi List, I have a query about loading huge amount of data into postgis. I am using shp2pgsql tool which is loading data with single channel only inside database. i.e. one shape file at a time. Is there any tool which can load multiple shape file at a time. Another query is that I want to store spatial data (above loaded)on file system and just pass the path or id to the database. How can i achieve that as to above loader load data inside database, which will increase the size of the database after loading huge amount of data. -- Thanks & Regards Dhaval Jaiswal | TS - Database
run multiple copies of shp2pgsql, like: shp2pgsql shape1 & shp2pgsql shape2 & ... > Another query is that I want to store spatial data (above loaded)on file > system and just pass the path or id to the database. Not sure what you are asking, how about store the filename in the database? -Andy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
