Howdy:
Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
I know this will sound stupid, but can someone
tell me what this means: 'PC color icon data' ?
Background: I copy a table out to a .txt file
by doing this:
[snip]
psql -U postgres -d bcn -c "\\copy measures to
'/tmp/fiveyears.txt' using delimiters '\|'"
[/snip]
and when I use it elsewhere or if I type 'file' to
make sure it's a text file, I get this:
[snip message]
[admin@localserver test]$ file fiveyears.txt
fiveyears.txt: PC color icon data
[/snip message]
I am looking at the owner of this data and I see
a pattern, but I've never heard of something like
this. So, my *real* question should be:
How does PostgreSQL figure out what the difference
when copying a file? I have things like "ASCII text",
"ASCII C++ program text", "Netpbm PBM image text",
"Non-ISO extended-ASCII English text, with LF,
NEL line terminators", etc ... and can I convert
them to just ASCII?
Thanks!
-X
