CODEWITHSUNDEEP
postgresqlbinarycopy
Chen Keinan
Chen Keinan

Reputation: 360

postgres copy command using binary field

I would like to use the PostgreSQL copy command were one of the fields is a binary field, which value should I put in the CSV in order to use the copy command from CSV to the new table which has a binary field

Upvotes: 0

Views: 244

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247455

On reasonably recent PostgreSQL versions, that would be

\xDEADBEEF

for a 4-byte bytea.

Upvotes: 1

Related Questions