Re: Need a command to take the backup of the child tables along with its master table.

On Thu, Jan 24, 2019 at 11:01 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
> If not, you'll have to do some bash magic in parsing the "Foreign-key constraints:" clause of "\d your_table_name" and stuff them in the "pg_dump --table=" clause.

That would be hard. There is an option to make psql show the queries
it uses to implement \d. Reading that it is normally easy to buld a
query which lists the dependents by creative imitation and feed it to
psql ( instead of the \d ) with the approppiate context setting
options to spit the table names, or even the --table="xx" list,
including schemas and other niceties.

And if his shell is not bash, but CMD.EXE or other similar thing,
parsing \d output will be hell.

Francisco Olarte.