Re: proposal: possibility to read dumped table's name from file
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>,
Daniel Gustafsson <daniel@yesql.se>,
Pavel Stehule <pavel.stehule@gmail.com>,
Justin Pryzby <pryzby@telsasoft.com>,
Dean Rasheed <dean.a.rasheed@gmail.com>,
Stephen Frost <sfrost@snowman.net>,
Surafel Temesgen <surafel3000@gmail.com>,
vignesh C <vignesh21@gmail.com>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2021-07-12T23:16:35Z
Lists: pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes: > [1] your proposal of "[+-] OBJTYPE OBJIDENT" plus empty lines allowed > plus lines starting with # are comments, seems plenty. Any line not > following that format would cause an error to be thrown. I'd like to see some kind of keyword on each line, so that we could extend the command set by adding new keywords. As this stands, I fear we'd end up using random punctuation characters in place of [+-], which seems pretty horrid from a readability standpoint. I think that this file format should be designed with an eye to allowing every, or at least most, pg_dump options to be written in the file rather than on the command line. I don't say we have to *implement* that right now; but if the format spec is incapable of being extended to meet requests like that one, I think we'll regret it. This line of thought suggests that the initial commands ought to match the existing include/exclude switches, at least approximately. Hence I suggest include table PATTERN exclude table PATTERN which ends up being the above but with words not [+-]. regards, tom lane
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Fix array subscript warnings
- 17935e1fdf0a 17.0 landed
-
Read include/exclude commands for dump/restore from file
- a5cf808be55b 17.0 landed
-
Allow records to span multiple lines in pg_hba.conf and pg_ident.conf.
- 8f8154a503c7 14.0 cited