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 or flat)
Thread:
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
string.

New screenshots at http://developer.pgadmin.org/~guillaume/importtool/

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.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

In response to

Responses

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-2014 The PostgreSQL Global Development Group