u's PATH have no problem? -----ååéä----- åää: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] David F. Skoll åéæé: 2003å12æ30æ 6:24 æää: Charles Haron æé: [EMAIL PROTECTED] äé: Re: [ADMIN] How to use psql -c?
On Mon, 29 Dec 2003, Charles Haron wrote: > I want to be able to run the above command as a cron job. I created a > script with the following command, but I get "ERROR: Attribute 'f' not > found": > su - postgres -c 'psql -c "DELETE FROM prg_dates_members WHERE confirm = > 'f';" comfire' Why not avoid shell quoting problems by doing it like this: su - postgres -c psql comfire <<EOF DELETE FROM prg_dates_members WHERE confirm = 'f'; EOF Regards, David. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.556 / Virus Database: 348 - Release Date: 2003-12-26 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.556 / Virus Database: 348 - Release Date: 2003-12-26 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
