| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stéphane Tachoires <stephane(dot)tachoires(at)gmail(dot)com> |
| Cc: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, Fabrice Chapuis <fabrice636861(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> |
| Subject: | Re: pg_restore remap schema |
| Date: | 2022-11-16 15:10:20 |
| Message-ID: | 1343019.1668611420@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
=?UTF-8?Q?St=C3=A9phane_Tachoires?= <stephane(dot)tachoires(at)gmail(dot)com> writes:
> And could it be at pg_dump level ?
> It seems more aware of what is doing...
pg_dump would be in a slightly better position, but only slightly.
It still has no idea about the contents of function bodies.
Also, if it's acceptable to do this at dump time, you could just
temporarily rename the schema on the server while making the dump.
(Not that that would fix function bodies either.)
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2022-11-16 15:14:39 | Re: pg_restore remap schema |
| Previous Message | Stéphane Tachoires | 2022-11-16 14:58:29 | Re: pg_restore remap schema |