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