Re: Idea for making COPY data Microsoft-proof

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Idea for making COPY data Microsoft-proof
Date: 2002-02-12 00:02:43
Message-ID: 18188.1013472163@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> No big deal, but this seems to be an encoding issue; and it seems like a
> good idea to formalize it somehow.

Well, currently there is a strict separation between COPY data (in the
file) and metadata (supplied as parameters to the COPY command). I'm
not eager to revisit that decision. What you seem to be suggesting is
shoving metadata into the data file, but I think that will create more
problems than it solves. To take just one problem: how do I know that
the first line is metadata, and not data that happens to look exactly
like whatever my metadata layout is?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2002-02-12 00:15:24 Re: Idea for making COPY data Microsoft-proof
Previous Message Philip Warner 2002-02-11 23:58:49 Re: Idea for making COPY data Microsoft-proof