> From: "David F. Skoll" <[EMAIL PROTECTED]> > Date: Mon, 29 Dec 2003 17:23:53 -0500 (EST) > To: Charles Haron <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: 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 >
If I use this as is I get: EOF: command not found > Regards, > > David. > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
