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

[Randall, Eric]

What about? 

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

Eric


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
Daniel Grum
Sent: Thursday, September 03, 2009 9:16 AM
To: PostGIS Mailing-List
Subject: [postgis-users] to run a xxx.sql by run a xxx.bat file


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


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users