Re: Issues with pg_dump command

On Wed, Nov 18, 2020 at 02:37:50PM +0000, Lior Dahan wrote:
> Is there a way we can tell which tables are under this parent one? Perhaps we can dump them instead.

Well, in psql, \d will show you the children:

    CREATE TABLE parent (x int);
    
    CREATE TABLE child (y int) INHERITS (parent);
    
    \d parent
        Table "public.parent"
     Column |  Type   | Modifiers
    --------+---------+-----------
     x      | integer |
-->    Number of child tables: 1 (Use \d+ to list them.)

    test=> \d+ parent
                            Table "public.parent"
     Column |  Type   | Modifiers | Storage | Stats target | Description
    --------+---------+-----------+---------+--------------+-------------
     x      | integer |           | plain   |              |
-->    Child tables: child

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee