[postgis-users] PostGIS command line options

Steffen Macke sdteffen at gmail.com
Fri Apr 20 11:27:05 PDT 2007


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



More information about the postgis-users mailing list