Skip site navigation (1) Skip section navigation (2)

COPY CSV header line feature

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: COPY CSV header line feature
Date: 2005-03-13 23:32:20
Message-ID: 4234CD84.6010004@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-patches
The attached patch implements the previously discussed header line
feature for CSV mode COPY. It is triggered by the keyword HEADER (blame
Bruce - he chose it ;-) ).
 
On input this feature causes the first line to be ignored; on output it
generates a line of column names. This will make playing with
spreadsheets potentially a lot nicer.

Docs and regression tests will be forthcoming.

cheers

andrew

Attachment: csv-header.patch
Description: text/x-patch (9.6 KB)

Responses

pgsql-patches by date

Next:From: Neil ConwayDate: 2005-03-13 23:47:20
Subject: Re: pgcrypto: openssl digest fix
Previous:From: Greg StarkDate: 2005-03-13 22:35:27
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low. [final?]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group