Hi all, The sequence of commands that I used and their outputs are as below:
shreer...@ubuntu:~/Shapefiles/ 06001_Alameda_County/tl_2008_06001_arealm$ shp2pgsql -s 4326 -I -S tl_2008_06001_arealm.shp public.testdb > tl_2008_06001_arealm.sql Shapefile type: Polygon Postgis type: POLYGON[2] shreer...@ubuntu:~/Shapefiles/06001_Alameda_County/tl_2008_06001_arealm$ psql -d testdb -h localhost -p 5432 -U postgres Welcome to psql 8.3.9 (server 8.4.2), the PostgreSQL interactive terminal. testdb=# psql -d testdb -U postgres -f tl_2008_06001_arealm.sql What should be the output of this command at the terminal? On entering this command the terminal gives a new promt. Is this the desired output? When I use the command testdb-# \d I get the output as: List of relations Schema | Name | Type | Owner --------+------------------+-------+---------- public | geometry_columns | table | postgres public | spatial_ref_sys | table | postgres (2 rows) Please help guys!!! _______________________________________ Pune GNU/Linux Users Group Mailing List