On Thu, Jan 24, 2019 at 11:01 AM Ron <ronljohnsonjr@gmail.com> wrote:
> If not, you'll have to do some bash magic in parsing the "Foreign-key constraints:" clause of "\d your_table_name"
andstuff 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.
