Home > mailing lists

Vacumdb Command Problem - Mailing list pgsql-sql

From	komala pelleti
Subject	Vacumdb Command Problem
Date	July 26, 2018 16:38:55
Msg-id	CAK=G_euBv0xvKKK=H=b1+OAaJRp+6t0sdwQQKynobpBGUvbTfg@mail.gmail.com Whole thread Raw
Responses	Re: Vacumdb Command Problem (hubert depesz lubaczewski <depesz@depesz.com>)
List	pgsql-sql

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 ?

Thanks N Regards

Komala P

8147106141.

From: Brice André
Date: 07 July 2018, 12:42:13
Subject: Re: Problem inserting binary data in bytea column of UTF-8 database

From: hubert depesz lubaczewski
Date: 26 July 2018, 17:41:52
Subject: Re: Vacumdb Command Problem