Re: How to use psql -c?

> From: "David F. Skoll" <dfs(at)roaringpenguin(dot)com>
> Date: Mon, 29 Dec 2003 17:23:53 -0500 (EST)
> To: Charles Haron <charles(dot)haron(at)cognitive(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)org
> 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.
>