On Thu, Jul 26, 2018 at 04:08:55PM +0530, komala pelleti wrote:
> Hi
> I have vaccume one of the schema on basis of pct_dead count.
>
> so my schema contains special character"_".
>
> it is giving error saying that :
>
> vacuumdb -d cidb -U postgres -t "test-services".monitoredresource;
>
> vacuumdb: vacuuming of table "test-services.monitoredresource" in database
> "cidb" failed: ERROR: syntax error at or near "-"
>
> how to correct this ?
Try:
vacuumdb -d cidb -U postgres -t '"test-services".monitoredresource'
Best regards,
depesz