pg_dump empty tables

From: Edu Gargiulo <egargiulo(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_dump empty tables
Date: 2020-06-23 13:30:53
Message-ID: CAD_UXMbu6Xy5ESEdAa2-o7vVN6O300exNYsywjcMZqg-SWz6hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

We are using postgresql 11.7 on Debian.
I noticed that pg_dump is not including records on tables with fields
defined as array type (integer[] and real[]). The table structure is
normally restored but they have 0 records on restoring.

i'm wondering if is it a normal behaviour of pg_dump and how should I
execute it to include data on that tables.

Any hint would be appreciated. Thanks in advance and sorry for my english

--
edugarg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Ralph 2020-06-23 13:32:45 UPDATE on 20 Million Records Transaction or not?
Previous Message Klaudie Willis 2020-06-23 13:07:14 Re: n_distinct off by a factor of 1000