[postgis-users] to run a xxx.sql by run a xxx.bat file

Daniel Grum daniel.grum at unibw.de
Thu Sep 3 06:16:28 PDT 2009


Hi,

Has anybody worked with a BAT-File ???

I want to run SQL-file with a BAT-file.

My BAT file es this text:

C:\Programme\PostgreSQL\8.3\bin\psql  -h localhost -p 5432 postgres 
postgres < fog_of_war.sql

And PSQL load this but he has a problem because the data is not in der 
DB postgres, it is in the DB postgis.

And so he says: "ERROR ...Relation don't exists"

If I insert the information "-d postgis"-->

C:\Programme\PostgreSQL\8.3\bin\psql  -h localhost -p 5432 postgres 
postgres -d postgis < fog_of_war.sql

PSQL ignores this information and says:
"Kommandozeilenargument -d ignoriert" und "Kommandozeilenargument 
postgis ignoriert"

What can be the problem????

THX

--daniel





More information about the postgis-users mailing list