Re: Spatial data Loading and storing

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