Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxx
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux