Re: COPY FROM with CSV header

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COPY FROM with CSV header
Date: 2005-10-06 21:19:36
Message-ID: 434594E8.8040205@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jim C. Nasby wrote:

>Instead of ignoring the first line of a COPY FROM ... WITH CSV HEADER,
>what about allowing the first line to be used as a list of field names?
>This means you wouldn't have to include field order in the COPY command
>if the names matched field names in the table.
>
>
It was debated ... could be dangerous, and you'd need extra syntax,
since we couldn't make it the default.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-10-06 21:23:57 Re: [HACKERS] Best practices: MERGE
Previous Message smile khmer 2005-10-06 20:35:10 Error messages