Thread: PGAdmin III cool feature request.
Hello community! There already exists a nice feature that helps to script actions related to the object (i.e. create, insert, delete, update etc.) the one that is located when right-clicking the database tree but the only feature is to open a script in a new window. I think it would be far more useful to have a choice if a script is opened in a new window or copied to the clipboard as i.e. in SQL Server Management Studio (it also supports sending a script to the File or "Agent Job"). Thanks in advance, Piotr -- -------------------------------------------------------------- "TECHBAZA.PL" Sp. z o.o. Technologie WEB, eDB& eCommerce tel. (+4832) 7186081 fax. (+4832) 7003289 email: biuro@techbaza.pl web: http://www.techbaza.pl web: partner.techbaza.pl web: ekspert.techbaza.pl
Hi, On Sun, 2011-09-04 at 14:30 +0200, Piotr Czekalski wrote: > [...] > There already exists a nice feature that helps to script actions related > to the object (i.e. create, insert, delete, update etc.) the one that is > located when right-clicking the database tree but the only feature is to > open a script in a new window. > I think it would be far more useful to have a choice if a script is > opened in a new window or copied to the clipboard as i.e. in SQL Server > Management Studio (it also supports sending a script to the File or > "Agent Job"). > I don't really understand the need to copy to the clipboard? can you explain what you are trying to do? -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
W dniu 2011-09-05 15:09, Guillaume Lelarge pisze: > Hi, > > On Sun, 2011-09-04 at 14:30 +0200, Piotr Czekalski wrote: >> [...] >> There already exists a nice feature that helps to script actions related >> to the object (i.e. create, insert, delete, update etc.) the one that is >> located when right-clicking the database tree but the only feature is to >> open a script in a new window. >> I think it would be far more useful to have a choice if a script is >> opened in a new window or copied to the clipboard as i.e. in SQL Server >> Management Studio (it also supports sending a script to the File or >> "Agent Job"). >> > I don't really understand the need to copy to the clipboard? can you > explain what you are trying to do? > > Hi, Sure I can - details below. That's working efficiency about. I'm used to create an insert / update / delete script and paste them to the other window, usually with bigger portion of Pl/Pgsql code or even C#. It's usually much quicker to paste a ready script and modify it a little than write INSERT/UPDATE/CREATE etc. from scratch and you won't forget a column or mistype it. Right now, every time you ask PgAdmin to create a script it opens a new Query window. That is not necessary for programmers creating i.e. data access layer - simply copying the script to the clipboard to let you paste it to the code (i.e. Visual Studio or Eclipse) would be far more useful for most programmers. Right now the procedure is: 1. create a script, 2. mark script text, 3. copy to clipboard, 4. close window, then finally paste. The feature I'm asking causes to simplify it all: 1. create script to clipboard paste - that's all. Regards, Piotr -- -------------------------------------------------------------- "TECHBAZA.PL" Sp. z o.o. Technologie WEB, eDB& eCommerce tel. (+4832) 7186081 fax. (+4832) 7003289 email: biuro@techbaza.pl web: http://www.techbaza.pl web: partner.techbaza.pl web: ekspert.techbaza.pl
On Thu, 2011-09-08 at 10:59 +0200, Piotr Czekalski wrote: > W dniu 2011-09-05 15:09, Guillaume Lelarge pisze: > > Hi, > > > > On Sun, 2011-09-04 at 14:30 +0200, Piotr Czekalski wrote: > >> [...] > >> There already exists a nice feature that helps to script actions related > >> to the object (i.e. create, insert, delete, update etc.) the one that is > >> located when right-clicking the database tree but the only feature is to > >> open a script in a new window. > >> I think it would be far more useful to have a choice if a script is > >> opened in a new window or copied to the clipboard as i.e. in SQL Server > >> Management Studio (it also supports sending a script to the File or > >> "Agent Job"). > >> > > I don't really understand the need to copy to the clipboard? can you > > explain what you are trying to do? > > > > > Hi, > > Sure I can - details below. That's working efficiency about. > > I'm used to create an insert / update / delete script and paste them to > the other window, usually with bigger portion of Pl/Pgsql code or even C#. > It's usually much quicker to paste a ready script and modify it a little > than write INSERT/UPDATE/CREATE etc. from scratch and you won't forget a > column or mistype it. > > Right now, every time you ask PgAdmin to create a script it opens a new > Query window. > That is not necessary for programmers creating i.e. data access layer - > simply copying the script to the clipboard to let you paste it to the > code (i.e. Visual Studio or Eclipse) would be far more useful for most > programmers. > > Right now the procedure is: > 1. create a script, > 2. mark script text, > 3. copy to clipboard, > 4. close window, > then finally paste. > > The feature I'm asking causes to simplify it all: > 1. create script to clipboard > paste - that's all. > It won't simplify the table contextual menu which is already way too big. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Right, it does not, but most features doesn't ;-). Regards, P. > It won't simplify the table contextual menu which is already way too > big. > > -- -------------------------------------------------------------- "TECHBAZA.PL" Sp. z o.o. Technologie WEB, eDB& eCommerce tel. (+4832) 7186081 fax. (+4832) 7003289 email: biuro@techbaza.pl web: http://www.techbaza.pl web: partner.techbaza.pl web: ekspert.techbaza.pl