| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
| Cc: | pgman(at)candle(dot)pha(dot)pa(dot)us, pjw(at)rhyme(dot)com(dot)au, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: pg_restore recognizing $-quotes |
| Date: | 2004-08-18 15:33:45 |
| Message-ID: | 23042.1092843225@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
"Andrew Dunstan" <andrew(at)dunslane(dot)net> writes:
> ISTM that a very simple alternative would be to force pg_dump to
> inhibit dollar quoting for non-text dumps.
> ...
> OK. Not sure I understand why, though - the whole point of putting dollar
> quoting into pg_dump was to make text dumps nicer to read, I thought (and I
> outght to know ;-) ).
But you can get a text dump out of pg_restore.
Also, for testing purposes I think it's important that
"pg_dump -Fc | pg_restore" generate exactly the same script as pg_dump.
This is true currently (unless someone's broken it again recently)
and I don't want to give up the property.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-08-18 15:41:47 | Re: 7.4.3 & 8.0.0beta1 + Solaris 9: default pg_hba.conf breaks |
| Previous Message | Andrew Dunstan | 2004-08-18 15:31:01 | Re: pg_restore recognizing $-quotes |