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

Re: \Copy and "Copy With Headers" -- every day these bug me.

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>, John Abraham <jea(at)hbaspecto(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: \Copy and "Copy With Headers" -- every day these bug me.
Date: 2012-02-21 22:25:22
Message-ID: 476bef55b65c27c6c961989348dc3192@localhost (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
On Mon, 20 Feb 2012 21:11:17 +0100, Guillaume Lelarge
<guillaume(at)lelarge(dot)info> wrote:
> On Mon, 20 Feb 2012 09:15:07 +0000, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>> On Mon, Feb 20, 2012 at 7:31 AM, Guillaume Lelarge
>> <guillaume(at)lelarge(dot)info> wrote:
>>> Hi Ashesh,
>>> On Mon, 2012-02-20 at 10:20 +0530, Ashesh Vashi wrote:
>>>> [...]
>>>> I think - we should have some default values in some text controls.
>>>> i.e. Delimiter, Quote, Escape
>>> We can do exactly like the frmExport window: replacing text control
> with
>>> combobox. Comboboxes will have some usual values (like tab, comma, etc
>>> for delimiter), but offer the possibility to change them by anything a
>>> user would like.
>> +1
> This is done.

I've made more progress tonight. Now, the user can select which columns in
the table will be filled (of course, the file should only contain these
columns). He can also select which columns will be ignored for the NULL

New screenshots at

I'm now wondering if I should add a SQL tab, to show the query before it
gets executed.

Seems it's almost ready to get commited.

Comments welcomed.


In response to


pgadmin-support by date

Next:From: Guillaume LelargeDate: 2012-02-21 22:36:30
Subject: Re: Trigger Script Error
Previous:From: Bartosz DmytrakDate: 2012-02-21 20:53:49
Subject: Trigger Script Error

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