Search Postgresql Archives

More than one characters in DELIMITER (for COPY)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

We have data where all the characters on the keyboard are used. The
data is utf-8, so all of those European characters with umlauts and
such are also used. Because of this we have {~} as the delimiter, even
{} was taken!

Now when I try to specify this delimiter in the COPY command to import
the data into a table, I get the error message that the delimiter can
only be a single character. Why this requirement? Most databases allow
importing/exporting with any delimiter I wish!

I'd appreciate some thoughts on what my options are..

Thanks!



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux