Re: Re: Survey: renaming/removing script binaries (createdb, createuser...)

On Wed, Mar 26, 2008 at 10:02:45AM -0700, Steve Atkins wrote:
> What's the psql equivalent of the "standard" use case of "vacuumdb -a"?
> (If you don't know the answer, for both unix and windows, you don't get
> to vote for removing vacuumdb).

linux:
psql -qAt -c "select E'\\\\connect ' || datname || E'\nvacuum;' from pg_database where datallowconn" | psql

windows:
psql -qAt -c "select E'\\connect ' || datname || E'\nvacuum;' from pg_database where datallowconn" | psql

that's not actually complicated (i'm not saying it's nice, as it isn't).

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)