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

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