Re: pg_dump empty tables

On 6/23/20 6:30 AM, Edu Gargiulo wrote:
> 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.

What is the complete command you are using when running pg_dump?

What is the schema for one of the tables? e.g \dt table_name

What is does a SELECT on those fields show?

> 
> 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


-- 
Adrian Klaver
adrian.klaver@aklaver.com