PC color icon data?

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

Responses

Browse pgsql-general by date

  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