Home > mailing lists

Array syntax in the copier - Mailing list pgsql-general

From	Andy Chambers
Subject	Array syntax in the copier
Date	August 26, 2011 22:59:14
Msg-id	CAAfW55qbiJNB-XR41RHFJRTWyLWapnPcByydb5YhHN_V2AHNZg@mail.gmail.com Whole thread Raw
Responses	Re: Array syntax in the copier (pasman pasmański <pasman.p@gmail.com>)
List	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

From: CauBa
Date: 26 August 2011, 22:50:55
Subject: Need help with dropping a view please

From: "Winning Runner"
Date: 26 August 2011, 23:27:00
Subject: Looking at the contents of a WAL file