[postgis-users] Script

[alex bodnaru]

you could also use psql in batch mode:

psql -d your_database -f scriptname.sql,
or
psql -d your_database < scriptname.sql

alex

Robert Burgholzer wrote:
> If you are using the psql command line connection to Postgresql, then the following syntax will execute an SQL file named "scriptname.sql" that resides in the current working directory (where you invoked the psql command)"
> 
> \i scriptname.sql
> 
> HTH
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Maik Trömel
> Sent: Wednesday, November 09, 2005 10:32 AM
> To: Postgis Users
> Subject: [postgis-users] Script
> 
> Hi PostGIS-Users,
> 
> how can I run a script under postgresql?
> 
> Thanks for your help!
> 
> Greetings
> Maik
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>