[postgis-users] PostGIS command line options

Leigh Durland leighd at midwestsurveys.com
Fri Apr 20 11:45:48 PDT 2007


Thanks Steffen,

 I didn’t realize the postloading was actually a stored procedure, my mistake. But thanks for the tips that makes much more sense.

Greatly appreciated 
Leigh



-----Original Message-----
From: Steffen Macke [mailto:sdteffen at gmail.com] 
Sent: April 20, 2007 12:27 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS command line options

Hi Leigh,

> to do the "SELECT postloading" and VACUUM ANALYZE from this same shell
> script that I have created?  Any code would be greatly appreciated.

I'm not sure what "SELECT postloading" is. But you can issue
select statements and other statements from a shell using psql.
For example:

psql -c "VACUUM ANALYZE"

Note that most probably you'll have to add additional parameters
for user name, database, host, port, etc. See the PostgreSQL documentation
for this.

Regards,

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




More information about the postgis-users mailing list