Обсуждение: Spatial data Loading and storing

The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. 
Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon,this information by persons or entities other than the intended recipient is prohibited. 
If you received this in error, please contact the sender and delete the material from your computer. 
Microland takes all reasonable steps to ensure that its electronic communications are free from viruses. 
However, given Internet accessibility, the Company cannot accept liability for any virus introduced by this e-mail or any attachment and you are advised to use up-to-date virus checking software. 

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