Re: proposal: possibility to read dumped table's name from file - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: proposal: possibility to read dumped table's name from file
Date
Msg-id A1B264E5-6E4E-481A-B762-425B8D1BA0A6@yesql.se
Whole thread Raw
In response to Re: proposal: possibility to read dumped table's name from file  (Erik Rijkers <er@xs4all.nl>)
Responses Re: proposal: possibility to read dumped table's name from file
List pgsql-hackers
> On 8 Sep 2022, at 12:00, Erik Rijkers <er@xs4all.nl> wrote:
>
> Op 07-09-2022 om 21:45 schreef Daniel Gustafsson:
>> One thing this patchversion currently lacks is refined error messaging, but if
>> we feel that this approach is a viable path then that can be tweaked.  The
>> function which starts the parser can also be refactored to be shared across
>> pg_dump, pg_dumpall and pg_restore but I've kept it simple for now.
>> Thoughts?  It would be nice to get this patch across the finishline during this
>> commitfest.
>
> > [0001-Add-include-exclude-filtering-via-file-in-pg_dump.patch]
>
> This seems to dump & restore well (as Pavels patch does).

Thanks for looking!

> I did notice one peculiarity (in your patch) where for each table a few spaces are omitted by pg_dump.

Right, I had that on my TODO to fix before submitting but clearly forgot.  It
boils down to consuming the space between commands and object types and object
patterns. The attached v2 fixes that.

--
Daniel Gustafsson        https://vmware.com/


Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: why can't a table be part of the same publication as its schema
Next
From: Julien Rouhaud
Date:
Subject: Re: proposal: possibility to read dumped table's name from file