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.

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.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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

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
[mailtogadmin-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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster