Joseph Krogh wrote: >> You will never be able to insert a null character into a PostgreSQL database. >> You can either modify the source data or change the data in transit. > > This is not 100% true, but is true for text-fields. You can insert \0 into BYTEA columns.
I was talking about characters, not bytes.
'\0' is a character. I see noe specification of character-fields (like varchar and text) in your answer.