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