Thread: Vacumdb Command Problem

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