Re: Paste rows rough patch

> -----Original Message-----
> From: pgadmin-hackers-owner(at)postgresql(dot)org
> [mailto:pgadmin-hackers-owner(at)postgresql(dot)org] On Behalf Of
> Edward Di Geronimo Jr.
> Sent: 02 May 2006 06:26
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Paste rows rough patch
>
> Attached is a rough patch to allow pasting of rows into the
> edit grid.
> It's not intended to be a final solution, but rather enough
> to start some discussion.
>
> This patch is rather simple - it always deliminates columns
> by tabs, and stops if it hits a new line. It pastes data
> starting at the first column of the row the cursor is on.
> Right now it doesn't pay any attention to the column details,
> so it will gladly insert data into serial columns or whatever.
>
> I figure the proper solution should probably be to obey the
> copy settings for deliminating columns.

Yes - in particular the quote settings - I have lots of data containing
newlines for example, which this won't work with for obvious reasons.

> As to things like serial & oid columns, how does everyone
> feel about that? Maybe we could add an option to paste values
> in, skip the columns, or prompt?

OID columns should be ignored, but serial columns should be optional
imho - just a simple 'The data you are pasting include values that will
be inserted into a serial column. Do you want to skip the serial valules
and allow new ones to be assigned? Y/N' prompt at paste time.

Regards, Dave