[postgis-users] loading shapefiles into postgis db

Shaq Gbadebo s_gbadebo at hotmail.com
Fri Mar 4 11:28:22 PST 2005


Hello,
I really apprciate your assistance, and sorry for being such a pain.
The emmet database got a little messy, so decided to create a  new db 
"final", with a new schema, "theschema", as shown below.

bash-2.05b$ createdb final
CREATE DATABASE
bash-2.05b$ psql final

Welcome to psql 7.3.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

final=#
final=# create schema theschema;
CREATE SCHEMA

I have written the shp2pgsql output to a file "testing.sql"(which looks 
alright), but the command shp2pgsql -f <testing.sql> final keeps giving me 
the error - "final: No such file or directory".

THanks

Shaq





More information about the postgis-users mailing list