Thread: Execute TO in PgadminIII
The functionality execute to is not anymore present ? I currently use this functionality with pgadminII to export the queries result to Excell. Regards Gaetano Mendola
> -----Original Message----- > From: Gaetano Mendola [mailto:mendola@bigfoot.com] > Sent: 21 October 2003 19:45 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Execute TO in PgadminIII > > The functionality execute to is not anymore present ? > I currently use this functionality with pgadminII to export > the queries result to Excell. Hi, The functionality is in the development branch, but only execute to file. pgAdmin III has no knowledge of COM so cannot export directly to Excel (would be kinda tricky on Linux/FreeBSD anyway!). Regards, Dave.
Hi Dave, Dave Page wrote: > > > >>-----Original Message----- >>From: Gaetano Mendola [mailto:mendola@bigfoot.com] >>Sent: 21 October 2003 19:45 >>To: pgadmin-support@postgresql.org >>Subject: [pgadmin-support] Execute TO in PgadminIII >> >>The functionality execute to is not anymore present ? >>I currently use this functionality with pgadminII to export >>the queries result to Excell. > > > Hi, > > The functionality is in the development branch, but only execute to > file. pgAdmin III has no knowledge of COM so cannot export directly to > Excel (would be kinda tricky on Linux/FreeBSD anyway!). But simple HTML would do the trick for Excel and even OpenOffice can read this: <html> <body> <table> <tr> <th>column1</th><th>column2</th> </tr> <tr> <td>... and so on. Or maybe native OpenOffice, which is XML (in a Zip archive) Schould not be so hard. (This would help maintaining type information) Regards Tino Wildenhain
Dave Page wrote: > > > >>-----Original Message----- >>From: Gaetano Mendola [mailto:mendola@bigfoot.com] >>Sent: 21 October 2003 19:45 >>To: pgadmin-support@postgresql.org >>Subject: [pgadmin-support] Execute TO in PgadminIII >> >>The functionality execute to is not anymore present ? >>I currently use this functionality with pgadminII to export >>the queries result to Excell. > > > Hi, > > The functionality is in the development branch, but only execute to > file. pgAdmin III has no knowledge of COM so cannot export directly to > Excel (would be kinda tricky on Linux/FreeBSD anyway!). > > Regards, Dave. > Ok bu wat about to have a plug-in loadable only on windows for pgAdmin III that permit the export ? Gaetano
> -----Original Message----- > From: Gaetano Mendola [mailto:mendola@bigfoot.com] > Sent: 22 October 2003 10:38 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Execute TO in PgadminIII > > > Ok bu wat about to have a plug-in loadable only on windows > for pgAdmin III that permit the export ? pgAdmin III doesn't have plugin modules, and even if it did (or we used a #define) would still have a very tough job talking to Excel through COM. The easiest way would be to export to a text file, and load that into Excel. Regards, Dave.
Dave Page wrote: > > > >>-----Original Message----- >>From: Gaetano Mendola [mailto:mendola@bigfoot.com] >>Sent: 22 October 2003 10:38 >>To: Dave Page >>Cc: pgadmin-support@postgresql.org >>Subject: Re: [pgadmin-support] Execute TO in PgadminIII >> >> >>Ok bu wat about to have a plug-in loadable only on windows >>for pgAdmin III that permit the export ? > > > pgAdmin III doesn't have plugin modules, and even if it did (or we used > a #define) would still have a very tough job talking to Excel through > COM. The easiest way would be to export to a text file, and load that > into Excel. I don't like it to have this missing feature passing from pgAdminII to pgAdminIII, one reason for us to not use it. I really don't have time to do it but define a general mechanism for load external libraries and have plug-in could be really great. For example on Linux could be possible export a result set to Gnumeric. Gaetano
Hi Dave, Dave Page wrote: > > > >>-----Original Message----- >>From: Gaetano Mendola [mailto:mendola@bigfoot.com] >>Sent: 22 October 2003 10:38 >>To: Dave Page >>Cc: pgadmin-support@postgresql.org >>Subject: Re: [pgadmin-support] Execute TO in PgadminIII >> >> >>Ok bu wat about to have a plug-in loadable only on windows >>for pgAdmin III that permit the export ? > > > pgAdmin III doesn't have plugin modules, and even if it did (or we used > a #define) would still have a very tough job talking to Excel through > COM. The easiest way would be to export to a text file, and load that > into Excel. Very sexy would be this: http://www.python.org/doc/current/ext/embedding.html So we would be able to develop a zillon of plugins for every platform - just as a script hook for pgAdmin :-) On Windows one can talk to .com, on Unix do other things. Write small little scripts for tedius tasks... At least its good documented and there is code to borrow from, for example in xchat. Regards Tino Wildenhain
> -----Original Message----- > From: Tino Wildenhain [mailto:tino@wildenhain.de] > Sent: 22 October 2003 12:31 > To: Dave Page > Cc: Gaetano Mendola; pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Execute TO in PgadminIII > > Very sexy would be this: > http://www.python.org/doc/current/ext/embedding.html > So we would be able to develop a zillon of plugins for every > platform - just as a script hook for pgAdmin :-) On Windows > one can talk to .com, on Unix do other things. > Write small little scripts for tedius tasks... > > At least its good documented and there is code to borrow > from, for example in xchat. I have been wanting to look at this sort of thing for a while, just never got around to it. I will investigate further when I get more time (big software rollout on Monday). Regards, Dave
Tino Wildenhain wrote: > > Very sexy would be this: > http://www.python.org/doc/current/ext/embedding.html > So we would be able to develop a zillon of plugins > for every platform - just as a script hook for > pgAdmin :-) Yes, Python *is* sexy, it's my first choice. We certainly shouldn't reinvent the wheel developing another kind of snapin technology. There's a wxPython too, maybe this could help us integrating the python scripting engine. BTW this is certainly a hackers topic, let's keep this list dedicated to user's problem with existing features. Regards, Andreas