[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