| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | komala pelleti <p(dot)komala(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Vacumdb Command Problem |
| Date: | 2018-07-26 11:41:52 |
| Message-ID: | 20180726114152.pcaty4gegr2awziq@depesz.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emiliano Amilcarelli | 2018-07-26 20:18:05 | test mail |
| Previous Message | komala pelleti | 2018-07-26 10:38:55 | Vacumdb Command Problem |