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: Dave Page <dpage(at)pgadmin(dot)org>
Cc: 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-23 22:15:34
Message-ID: 1330035334.19409.1.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgadmin-support
On Tue, 2012-02-21 at 23:25 +0100, Guillaume Lelarge wrote:
> 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.
> 

No comments, so I commited the patch (actually with a few fixes that I
think were required).

The import tool will be available with 1.16.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


In response to

pgadmin-support by date

Next:From: Colin BeckinghamDate: 2012-02-24 11:35:46
Subject: Error "column not found in pgSet: current_query"
Previous:From: Colin BeckinghamDate: 2012-02-23 18:41:43
Subject: Panel height redimensioning in Query builder

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