Johnson, Shaunn writes:
> I'm trying to load data from a text file that
> has an odd character in it (^@). From what I
> could tell, it's a NULL character. How can I
> load that into the database via the command line?
Depends on what data type the column is supposed to have. Character data
types cannot contain null bytes. The type bytea can store arbitrary
binary data. It requires you to escape null bytes so '\\000'.
--
Peter Eisentraut peter_e@gmx.net