Control-C works here. What platform are you on? Can you reproduce it?
I just tried:
psql -c 'select * from pg_class, pg_proc' test
and control-C terminated the query.
---------------------------------------------------------------------------
Kenji Sugita wrote:
> Vacuumdb command can't be canceled by Control-C and VACUUM is still running.
> When wrong database name is specified to vacuumdb, cancellation is required to
> stop VACUUM FULL which runs long.
>
> Option -c of psql forget to set signal handler for 7.3 or prior. Vacuumdb
> have no signal handler of cancellation for 7.4devel.
>
>
> Kenji Sugita
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073