Postgres Pro
Downloads
Home   >   mailing lists

Using psql on command line - Mailing list pgsql-general

From Brian
Subject Using psql on command line
Date
Msg-id Pine.LNX.4.02.9809040955210.5167-100000@mercury.shreve.net
Whole thread Raw
Responses Re: [GENERAL] Using psql on command line
Re: [GENERAL] Using psql on command line
List pgsql-general
Tree view 
I would like to run a cron job nightly to vaccuum a few databases, but how
do you execute from just a command line?  I tried like:

psql mydb < vacuum
psql mydb | vacuum

etc.

Thanks.

Brian


--------------------------------------------------------------------------
Brian Feeny (BF304)   | ShreveNet Inc. - Premium Internet Service Provider
Network Administrator | Shreveport, Louisiana - http://www.shreve.net/
signal@shreve.net     | Web Hosting, Virtual Domains, Storefronts,
(318)222-2NET x 109   | Database/Web Integration, 56k, ISDN, T1

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: CIDR/IP types. Was: [GENERAL] big numbers]
Next
From: Eric Marsden
Date:
Subject: Re: [GENERAL] Using psql on command line