Re: WIP Patch: pg_dump structured

2023-03-23 Thread Attila Soki
On 12 Mar 2023, at 22:56, Attila Soki wrote: >> On 12 Mar 2023, at 21:50, Tom Lane wrote: >> Won't this fail completely with SQL objects whose names aren't suitable >> to be pathname components? "A/B" is a perfectly good name so far as >> SQL is concerned. You could also have problems with

Re: WIP Patch: pg_dump structured

2023-03-12 Thread Attila Soki
> On 12 Mar 2023, at 21:50, Tom Lane wrote: > > Attila Soki writes: >> This patch adds the structured output format to pg_dump. >> This format is a plaintext output split up into multiple files and the >> resulting small files are stored in a directory path based on the dumped >> object. >

Re: WIP Patch: pg_dump structured

2023-03-12 Thread Tom Lane
Attila Soki writes: > This patch adds the structured output format to pg_dump. > This format is a plaintext output split up into multiple files and the > resulting small files are stored in a directory path based on the dumped > object. Won't this fail completely with SQL objects whose names

WIP Patch: pg_dump structured

2023-03-12 Thread Attila Soki
Hi all, I was looking for a way to track actual schema changes after database migrations in a VCS. Preferably, the schema definition should come from a trusted source like pg_dump and should consist of small files. This patch was born out of that need. This patch adds the structured output