Title: RE: [GENERAL] using copy to load odd characters
--howdy:
--to reiterate the problem, i am simply doing
--a copy of a text file into a table:
[snip example]
testdb> \copy t_test1 from '/var/tmp/results.txt' with delimiter as '|'
[/snip example]
--the
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
typ
Title: using copy to load odd characters
Howdy:
Running PostgreSQL 7.3.3 on RedHat Linux 7.2
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?
I've do
