Array syntax in the copier

From: Andy Chambers <achambers(at)mcna(dot)net>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Array syntax in the copier
Date: 2011-08-26 22:53:45
Message-ID: CAAfW55qbiJNB-XR41RHFJRTWyLWapnPcByydb5YhHN_V2AHNZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

What's the correct method of writing array columns using the bulk copier.
It seems to support the
curly braces notation but how do you escape special characters like ","?

I tried using "\x2c" and that prevents the syntax error but I end up with
what looks like the string
\x2c in the database.

Thanks,
Andy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Winning Runner 2011-08-26 23:20:10 Looking at the contents of a WAL file
Previous Message CauBa 2011-08-26 22:50:47 Need help with dropping a view please