Hi Xiaoyu,
If I understood your problem correctly, you are trying to load some ESRI shape
files into PostGIS database, right?
if so, try the following with psql
>>psql -d dbname -h dbhost -U username -f mysql.sql
dbname - the name of your PostGIS database
dbhost - the host of your PostGIS database
username - your user name to log in to your database
and mysql.sql - the .sql file you created at the first step
this is the syntax you should use to load the data into PostGIS database (as it
is in the manual of PostGIS, use Loader/Dumper keywords to google around and
find more on it)
hope this helps,
Ervin,
Date: Tue, 19 Aug 2008 10:20:29 +0200
From: [EMAIL PROTECTED]
To: [email protected]
Subject: [postgis-users] pgAdminIII crashes when import SQL
Dear all:
Here I have some problems with pgAdminIII. I am not a PostGIS export,(neither
SQL). but I still want to use PostGIS. I have two ESRI shapefiles. each file
have many attribute. here is some steps what I did.
Step 1. shp2pgsql. (win xp)
shp2pgsql -s 4326 -i -I myshapefile.shp myshapefile > myshapefile.sql
this step is work fine. I got two sql files, one is over 445MB, another one is
over 122MB.
Step 2. using query tools in pgAdmin III .
crashes happpens when I am opening the two sql file in query tools of my
database. my pc is Intel Core Dual, 2GB ram, then XP warning is that some
memory(0x00b45d2c) could not be writen. I attached screen shot.
some others. then I try to use psql command.
psql -d mydatabase -f myshapefiles.sql
then I am not sure how psql works. I can use QGIS open the database, but not my
GeoServer or uDig.
is there anyboday have similar situations before?
All the best
Xiaoyu
--
Xiaoyu Guan (Sam)
Geo-information Science
Wageningen UR
_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
