Re: Vacumdb Command Problem

hubert depesz lubaczewski <[email protected]> Thu, 26 Jul 2018 13:41:52 +0200

Newsgroups	gmane.comp.db.postgresql.sql
Message-ID	<[email protected]>

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