Re: PGAdmin and records as inserts (like in SQLyog) - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: PGAdmin and records as inserts (like in SQLyog)
Date
Msg-id 49898E6F.3080405@iol.ie
Whole thread Raw
In response to PGAdmin and records as inserts (like in SQLyog)  (durumdara <durumdara@gmail.com>)
List pgsql-general
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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: durumdara
Date:
Subject: PGAdmin and user privileges - what I do wrong?
Next
From: Raymond O'Donnell
Date:
Subject: Re: PGAdmin and user privileges - what I do wrong?