Thread: PgAdmin Wishlist: export to clipboard
<br />I allready can export query results to a text file as CSV.<br /><br />With ...another database and another tool...I often use the "export to clipboard" functionality for exporting a small amount of query results. (i.e . "distinctvalues in the "title" field of addresses"<br /><br />Possible placement would be within the "Export" Dialog,<br/>make a radio select <br /><br />( ) Filename [filenameselector]<br />( ) to Clipboard <br /><br />as wx has awx.Clipboard-class -> that may be doable, or?<br /><br />Best wishes<br /><br />Harald<br clear="all" /><br />-- <br/>GHUM Harald Massa<br />persuadere et programmare<br />Harald Armin Massa<br />Reinsburgstraße 202b <br />70197 Stuttgart<br/>0173/9409607<br />-<br />Python: the only language with more web frameworks than keywords.
Dear Harald, If I'm getting you right, you are looking for exporting the result grid of a query via Clipboard, right? The function is already there. Procedure: run a query as usual, an get the result in the grid. Click on the caret left top on the grid, where the column-names and row-numbers intersect. This will mark the whole result set (alternatively you can mark the lines individually, if so desired) Now go with CTRL-C for Copy and paste the content with CTRL-V in the context you desire. pgAdmin-Team. The above works great, as far as it comes to plain-text. When trying to paste the clipboard to Excel (German version) - it wouldn't work, because the default column separator is TAB and not selicolon. (it might work in English environment?) Would it be possible to implement the setup for clipboard export configurable? I saw that in other tools and love it. Then the copy and paste to (German)-Excel would be a snap. Thanks an regards Mathais Durst Harald Armin Massa schrieb: > > I allready can export query results to a text file as CSV. > > With ...another database and another tool... I often use the "export > to clipboard" functionality for exporting a small amount of query > results. (i.e . "distinct values in the "title" field of addresses" > > Possible placement would be within the "Export" Dialog, > make a radio select > > ( ) Filename [filenameselector] > ( ) to Clipboard > > as wx has a wx.Clipboard-class -> that may be doable, or? > > Best wishes > > Harald > > -- > GHUM Harald Massa > persuadere et programmare > Harald Armin Massa > Reinsburgstraße 202b > 70197 Stuttgart > 0173/9409607 > - > Python: the only language with more web frameworks than keywords.
Mathias Durst wrote: > Dear Harald, > > Would it be possible to implement the setup for clipboard export > configurable? > I saw that in other tools and love it. > Then the copy and paste to (German)-Excel would be a snap. Err, you can - see the result copy options: http://www.pgadmin.org/docs/1.6/options-tab3.html Regards, Dave.
Hello, if I can wish something, it would be an Export in the Format pg_dump is using (as a Script). This would be very helpfull. Greetings Michael Möhle -----Ursprüngliche Nachricht----- Von: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org]Im Auftrag von Dave Page Gesendet: Mittwoch, 17. Januar 2007 10:55 An: Mathias Durst Cc: Harald Armin Massa; pgAdmin Support Betreff: Re: [pgadmin-support] PgAdmin Wishlist: export to clipboard Mathias Durst wrote: > Dear Harald, > > Would it be possible to implement the setup for clipboard export > configurable? > I saw that in other tools and love it. > Then the copy and paste to (German)-Excel would be a snap. Err, you can - see the result copy options: http://www.pgadmin.org/docs/1.6/options-tab3.html Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster