From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | PC color icon data? |
Date: | 2003-08-01 14:19:29 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB05FED64C@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Shridhar Daithankar | 2003-08-01 14:33:28 | Re: Table Stats |
Previous Message | Ron Johnson | 2003-08-01 14:19:15 | Re: UPDATE sql question |