Re: PGAdmin and records as inserts (like in SQLyog)

On 04/02/2009 12:31, durumdara wrote:
> I wanna ask, that have the PGAdmin same possibility (like in SQLyog) to
> copy records (from the Query, from the Table View) to clipboard in the
> "INSERT SQL" format?
>
> This can speed up the work, and I can insert the record to another table
> that have similar (but a little different) format without field content
> confusion.

I don't think so, but you can use the pg_dump utility with the -D option
to generate plain-text dump files with INSERT statements and column
specifiers; then copy-and-paste the rows you need via your favourite
text editor.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------