| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andy Shellam <andy-lists(at)networkmail(dot)eu> |
| Cc: | dx k9 <bitsandbytes88(at)hotmail(dot)com>, posgres support <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: reindexdb -t schema.table name |
| Date: | 2009-06-09 20:39:54 |
| Message-ID: | 28351.1244579994@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Andy Shellam <andy-lists(at)networkmail(dot)eu> writes:
> Could it be an option that if the table name is already qualified and
> quoted, reindexdb doesn't touch it?
One small problem with the examples you give is that the shell would
immediately strip all the double-quotes. By the time you've made it
shell-safe it's pretty ugly.
See also the pg_dump switches for selecting tables, which are a lot
more sophisticated than reindexdb or the other clients have got.
If anything at all is done in this area, it should be compatible
with what pg_dump does.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hapase, Pranjali | 2009-06-10 05:57:15 | Regarding PostgreSQL problem. |
| Previous Message | Andy Shellam | 2009-06-09 20:29:39 | Re: reindexdb -t schema.table name |