<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'><div style="text-align: left;">Hi Xiaoyu,<br><br>If I understood your problem correctly, you are trying to load some ESRI shape files into PostGIS database, right?<br><br>if so, try the following with psql<br><br>>>psql -d dbname -h dbhost -U username -f mysql.sql<br><br>dbname - the name of your PostGIS database<br>dbhost - the host of your PostGIS database<br>username - your user name to log in to your database<br>and mysql.sql - the .sql file you created at the first step<br><br>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)<br><br></div>hope this helps,<br><br>Ervin,<br><br><br><hr id="EC_stopSpelling">Date: Tue, 19 Aug 2008 10:20:29 +0200<br>From: guanxiaoyu@gmail.com<br>To: postgis-users@postgis.refractions.net<br>Subject: [postgis-users] pgAdminIII crashes when import SQL<br><br><div dir="ltr">Dear all:<br>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. <br>
Step 1. shp2pgsql. (win xp)<br>shp2pgsql -s 4326 -i -I myshapefile.shp myshapefile > myshapefile.sql<br><br>this step is work fine. I got two sql files, one is over 445MB, another one is over 122MB. <br><br>Step 2. using query tools in pgAdmin III . <br>
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.<br><br>some others. then I try to use psql command. <br>
psql -d mydatabase -f myshapefiles.sql<br><br>then I am not sure how psql works. I can use QGIS open the database, but not my GeoServer or uDig. <br><br>is there anyboday have similar situations before?<br><br>All the best <br>
<br>Xiaoyu<br><br clear="all"><br>-- <br>Xiaoyu Guan (Sam)<br>Geo-information Science<br>Wageningen UR<br><br>
</div>
<br /><hr />Discover the new Windows Vista <a href='http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE' target='_new'>Learn more!</a></body>
</html>