[pgadmin-support] feature request: easier "view data" pane

2015-06-03 Thread Roger Pack
Hello. The most common complaint I hear about PgAdmin is "it takes me 6 clicks to actually get to viewing data" and I'll admit I find it a bit klunky myself. Suggestion/feature request: add another "tab" when you have selected a table that is "view data" and have the default be the first 100 rows

[pgadmin-support] Feature Request for pgAdmin Data Export

2015-04-30 Thread Frank Limpert
Dear developers, It would be nice to have the possibility to configure the decimal separator character and the group separator character for numeric columns when exporting data to file. I'm living in Germany, and Excel wants a comma as decimal separator character in my country. Today, I always h

Re: [pgadmin-support] feature request: "copy" full text

2015-04-01 Thread Dmitriy Olshevskiy
hi! there is a small trick: try to set this value to "-1" for max. possible length) however, it really would be nice to have a full-data-copy feature. On 31.03.2015 9:32, Paolo Saudin wrote: Just go to Options -> Query tools and the set the Max. characters per column Paolo Saudin Il giorno lu

Re: [pgadmin-support] feature request: "copy" full text

2015-03-30 Thread Paolo Saudin
Just go to Options -> Query tools and the set the Max. characters per column Paolo Saudin Il giorno lun 30 mar 2015 alle ore 23:24 Roger Pack ha scritto: > As a note, today's pgAdmin , when it has a long string and you > "ctrl+c" copy it, gives you this in the clipboard: > > > data data data (..

[pgadmin-support] feature request: "copy" full text

2015-03-30 Thread Roger Pack
As a note, today's pgAdmin , when it has a long string and you "ctrl+c" copy it, gives you this in the clipboard: data data data (...) (the string "(...)") Suggestion/feature request: "copy" the full data, so that we have a way to get to it "all" at all. Thank you very much. -roger- -- Sent

[pgadmin-support] feature request: change verbiage

2015-01-29 Thread Roger Pack
Hello. I noticed if I want to disconnect from a server, right click says " ... disconnect server ..." Suggestion/feature request: change it to say instead: ... disconnect from server ..." Then it doesn't sound like you're pulling the plug on the remote box as it does today. Just some feedback

Re: [pgadmin-support] feature request: better keyboard shortcuts for mac

2015-01-21 Thread Stephen Cook
On 1/21/2015 1:09 PM, Roger Pack wrote: might be nice to have some "standard" mac style keyboard shortcuts made available--for instance "command + left" should take you to the beginning of the current line [etc.] Let me know if you want/need a full list or anything else I could do here. I'd be h

[pgadmin-support] feature request: better keyboard shortcuts for mac

2015-01-21 Thread Roger Pack
might be nice to have some "standard" mac style keyboard shortcuts made available--for instance "command + left" should take you to the beginning of the current line [etc.] Let me know if you want/need a full list or anything else I could do here. I'd be happy to offer a small bounty for it as wel

[pgadmin-support] feature request: show and edit privileges on foreign tables

2014-09-18 Thread Frank Limpert
Hi All, It would be helpful to have privilege ACLs on foreign tables displayed in the SQL details field of the pgAdmin main window. Furthermore, it would be nice to have a "privileges" tab on the property dialogue of foreign tables as on the property dialogues of views and tables. The command

[pgadmin-support] Feature Request

2014-05-10 Thread Dave Barter
pgadmin is terrible for editing json in the database This could be fixed very quickly by allowing the use of an external editor -- Dave Barter Web: http://www.phased.co.uk Email:d...@phased.co.uk Twitter:@Citizenfishy

[pgadmin-support] feature request: option-left-arrow/option-right-arrow in SQL editor

2013-12-15 Thread Al Chou
Hi, I feel like this request must have been made before, but the archive search doesn't find anything. It would really be nice if the SQL editor responded to option-left-arrow on Mac OS X by moving the insertion point one word to the left (and analogously for option-right-arrow). I quite like

[pgadmin-support] feature request

2013-08-09 Thread Uwe Bartels
Hiho, first - thanks for the cool tool. I'd like to submit a feature request. when I delete table and recreate it on the commandline, and then try to refresh the table in pgadmin then the object in the tree is deleted. I guess because the referenced oid doesn't exist anymore. can you try to ref

Re: [pgadmin-support] feature request - automatic SSH tunnels

2013-04-19 Thread Dave Page
Hi On Thu, Apr 18, 2013 at 10:16 PM, Darren Duncan wrote: > On 2013.04.05 4:00 PM, Dave Page wrote: >> >> The patch is in my inbox. We've been having trouble with it on Mac, though >> it >> works fine on Linux and Windows (and is actually in the current release >> version >> of Postgres Enterpris

Re: [pgadmin-support] feature request - automatic SSH tunnels

2013-04-18 Thread Darren Duncan
On 2013.04.05 4:00 PM, Dave Page wrote: The patch is in my inbox. We've been having trouble with it on Mac, though it works fine on Linux and Windows (and is actually in the current release version of Postgres Enterprise Manager). Given that my platform is Mac, is there anything I can do to hel

Re: [pgadmin-support] feature request - automatic SSH tunnels

2013-04-05 Thread Dave Page
On Friday, April 5, 2013, Guillaume Lelarge wrote: > On Fri, 2013-04-05 at 11:30 -0700, Darren Duncan wrote: > > I have a feature request for pgAdmin that would help me and other users > a lot, > > and I don't see it on your roadmap or TODO. > > > > This is to add to Server Registration extra fiel

Re: [pgadmin-support] feature request - automatic SSH tunnels

2013-04-05 Thread Guillaume Lelarge
On Fri, 2013-04-05 at 11:30 -0700, Darren Duncan wrote: > I have a feature request for pgAdmin that would help me and other users a > lot, > and I don't see it on your roadmap or TODO. > > This is to add to Server Registration extra fields for configuring an SSH > tunnel > so that users can us

Re: [pgadmin-support] feature request - automatic SSH tunnels

2013-04-05 Thread Darren Duncan
On 2013.04.05 11:40 AM, Alexander Yerenkow wrote: Darren in whish OS your users are working currently? And ssh passwords you see them as saved or as entered at each conect? Regards, Alexander Yerenkow Thanks for your quick response. We have a mixed-platform environment, but in particular I an

Re: [pgadmin-support] feature request - automatic SSH tunnels

2013-04-05 Thread Alexander Yerenkow
Darren in whish OS your users are working currently? And ssh passwords you see them as saved or as entered at each conect? Regards, Alexander Yerenkow 05.04.2013 21:31 пользователь "Darren Duncan" написал: > I have a feature request for pgAdmin that would help me and other users a > lot, and I d

[pgadmin-support] feature request - automatic SSH tunnels

2013-04-05 Thread Darren Duncan
I have a feature request for pgAdmin that would help me and other users a lot, and I don't see it on your roadmap or TODO. This is to add to Server Registration extra fields for configuring an SSH tunnel so that users can use pgAdmin over an SSH tunnel without having to separately setup the tu

Re: [pgadmin-support] Feature request: display index valid/invalid status

2013-03-24 Thread gabrielle
On Sat, Mar 23, 2013 at 5:00 AM, Dave Page wrote: > > I'm happy to attempt a patch for this myself, but will need some > assistance > > as I know very little C, and no C++ whatsoever. :) > > Excellent :-). What is your preferred development platform? I know you > have a Mac, but it might be a l

Re: [pgadmin-support] Feature request: display index valid/invalid status

2013-03-23 Thread Dave Page
Hi Gabrielle On Fri, Mar 22, 2013 at 7:21 PM, gabrielle wrote: > Hi there! > > I'm a fairly new user of PgAdmin. Thanks to the dev team for building a > great GUI :) > > I'd like to be able to view an index's valid/invalid status (indisvalid from > pg_catalog.pg_index) from PgAdmin. > > It looks

[pgadmin-support] Feature request: display index valid/invalid status

2013-03-22 Thread gabrielle
Hi there! I'm a fairly new user of PgAdmin. Thanks to the dev team for building a great GUI :) I'd like to be able to view an index's valid/invalid status (indisvalid from pg_catalog.pg_index) from PgAdmin. It looks like the logical place to put this is in the "Properties" tab for that index.

Re: [pgadmin-support] [FEATURE REQUEST] select encoding for logs reader

2012-12-10 Thread Bartosz Dmytrak
Hi, In my case WIN1250 works "fine" - only works, but not fine :) Still, there is no option to change encoding of logs reader. Totally agree: DBs encoding (and log line) could be different, but this feature will give user option to try. Regards, Bartek

Re: [pgadmin-support] [FEATURE REQUEST] select encoding for logs reader

2012-12-10 Thread Dave Page
On Mon, Dec 10, 2012 at 8:25 AM, Bartosz Dmytrak wrote: > Hi all > I have a proposition of a new feature: select of encoding which is used by > logs reader in server status window. It looks like pgAdmin assumes UTF8, so > sometimes gives an error. > It is possible to read files with different enco

[pgadmin-support] [FEATURE REQUEST] select encoding for logs reader

2012-12-10 Thread Bartosz Dmytrak
Hi all I have a proposition of a new feature: select of encoding which is used by logs reader in server status window. It looks like pgAdmin assumes UTF8, so sometimes gives an error. It is possible to read files with different encoding via postgres: eg: SELECT convert_from(pg_read_binary_file('pg

Re: [pgadmin-support] [feature request] split triggers into branches

2012-11-25 Thread Kozusznik Michal
a lot of bussines logic is implemented in db. splitting it into several triggers rather then using single one helps in code management. just fyi. with regards MK 25. 11. 2012 v 11:31, "Guillaume Lelarge" : > On Wed, 2012-10-24 at 13:48 +0200, Michal Kozusznik wrote: >> Hello >> Have you conside

Re: [pgadmin-support] [feature request] split triggers into branches

2012-11-25 Thread Guillaume Lelarge
On Wed, 2012-10-24 at 13:48 +0200, Michal Kozusznik wrote: > Hello > Have you considered to split triggers into branches? > I can imagine: > > * triggers > o insert > + before > + after > o update > + before > + after > o before >

[pgadmin-support] [feature request] split triggers into branches

2012-10-24 Thread Michal Kozusznik
Hello Have you considered to split triggers into branches? I can imagine: * triggers o insert + before + after o update + before + after o before + before + after Triggers which are set for multiple events would appear in all

Re: [pgadmin-support] feature request - restore with create

2012-09-20 Thread Guillaume Lelarge
On Thu, 2012-09-20 at 17:55 +, Belbin, Peter wrote: > This applies to the latest 1.16 pgAdmin release: > > Unless I am mistaken, via pgAdmin, we can only restore a database that exists. > You're not mistaken. > Ie: we have to select the database, secondary-click, and then choose > 'restore

[pgadmin-support] feature request - restore with create

2012-09-20 Thread Belbin, Peter
This applies to the latest 1.16 pgAdmin release: Unless I am mistaken, via pgAdmin, we can only restore a database that exists. Ie: we have to select the database, secondary-click, and then choose 'restore'. How about the option being added to the 'database' element in the tree, and then be abl

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 15:54 +0200, Jan-Peter Seifert wrote: > Hello, > > another thing came to my mind. > > pgAdmin III 1.14 does seem to commit the changes as soon as the new > value has been entered. > Wouldn't it be nice to display a warning or do a rollback if more than > one row had been upd

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 15:43 +0200, Jan-Peter Seifert wrote: > Hello, > > thank you very much for your feedback everyone! > > Am 14.07.2012 15:06, schrieb Dave Page: > > > > it would be nice to have additional/other fallback options ( via > > check box in pgAdmin's general options? ) to

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Jan-Peter Seifert
Hello, another thing came to my mind. pgAdmin III 1.14 does seem to commit the changes as soon as the new value has been entered. Wouldn't it be nice to display a warning or do a rollback if more than one row had been updated instead of one or none then? Thank you very much, Peter -- Sent via

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Jan-Peter Seifert
Hello, thank you very much for your feedback everyone! Am 14.07.2012 15:06, schrieb Dave Page: > > it would be nice to have additional/other fallback options ( via > check box in pgAdmin's general options? ) to identify rows for > editing in tables without primary keys. > > > I'

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 14:01 +0100, Thom Brown wrote: > On 14 July 2012 13:57, Guillaume Lelarge wrote: > > On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: > >> Use of the CTID system column would work. > > > > I don't see how that could work. CTIDs obviously are unique, but anyone, > > updati

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Sat, 2012-07-14 at 14:06 +0100, Dave Page wrote: > > > On Saturday, July 14, 2012, Guillaume Lelarge wrote: > On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: > > On 12 July 2012 12:20, Jan-Peter Seifert > wrote: > > > Hello, > > > > > > I h

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Dave Page
On Saturday, July 14, 2012, Guillaume Lelarge wrote: > On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: > > On 12 July 2012 12:20, Jan-Peter Seifert > > > > wrote: > > > Hello, > > > > > > I have a feature request for the 'Edit data' window that is available > for each table in pgAdmin. > > >

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Thom Brown
On 14 July 2012 13:57, Guillaume Lelarge wrote: > On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: >> Use of the CTID system column would work. > > I don't see how that could work. CTIDs obviously are unique, but anyone, > updating a line will get another CTID for this line. If you try to > up

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-14 Thread Guillaume Lelarge
On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote: > On 12 July 2012 12:20, Jan-Peter Seifert wrote: > > Hello, > > > > I have a feature request for the 'Edit data' window that is available for > > each table in pgAdmin. > > > > As the OID column is not guaranteed to contain unique OIDs Oops,

Re: [pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-12 Thread Thom Brown
On 12 July 2012 12:20, Jan-Peter Seifert wrote: > Hello, > > I have a feature request for the 'Edit data' window that is available for > each table in pgAdmin. > > As the OID column is not guaranteed to contain unique OIDs it would be nice > to have additional/other fallback options ( via check

[pgadmin-support] Feature request - Edit data and tables without a primary key

2012-07-12 Thread Jan-Peter Seifert
Hello, I have a feature request for the 'Edit data' window that is available for each table in pgAdmin. As the OID column is not guaranteed to contain unique OIDs it would be nice to have additional/other fallback options ( via check box in pgAdmin's general options? ) to identify rows for edi

Re: [pgadmin-support] Feature Request: No gui for creating user mappings

2012-04-16 Thread Guillaume Lelarge
On Mon, 2012-04-16 at 09:15 -0400, Paragon Corporation wrote: > I didn't see this on your list, but seems glaringly missing since. > > Using 1.14.2 > > There is no right-click menu for create a new FDW Foreign Server User > Mapping > Yes, this is missing since the first 1.14 release. Will wo

[pgadmin-support] Feature Request: No gui for creating user mappings

2012-04-16 Thread Paragon Corporation
I didn't see this on your list, but seems glaringly missing since. Using 1.14.2 There is no right-click menu for create a new FDW Foreign Server User Mapping Thanks, Regina

Re: [pgadmin-support] feature request - allow to set option is_called for setval

2012-03-29 Thread Guillaume Lelarge
On Tue, 2012-03-27 at 08:58 +0200, Bartosz Dmytrak wrote: > Hi, > I just noticed pgAdmin cannot set value of sequence to start with 1 because > generates SQL like this: > SELECT setval('"MySchema"."MySequence"', 1, true); > > it is not possible to set "is_called" option of setval to false. > Accor

[pgadmin-support] feature request - allow to set option is_called for setval

2012-03-26 Thread Bartosz Dmytrak
Hi, I just noticed pgAdmin cannot set value of sequence to start with 1 because generates SQL like this: SELECT setval('"MySchema"."MySequence"', 1, true); it is not possible to set "is_called" option of setval to false. According to doc ( http://www.postgresql.org/docs/9.1/static/functions-sequen

Re: [pgadmin-support] feature request

2012-03-12 Thread Guillaume Lelarge
On Sat, 2012-03-10 at 21:51 +0100, Bartosz Dmytrak wrote: > Hi, > I second the request. > I am not wxWidgets developer but I think there are to different UI > solutions: > * different tabs in output section like in SQL Workbench > * different record sets like in MS (something like table

Re: [pgadmin-support] feature request

2012-03-10 Thread Bartosz Dmytrak
Hi, I second the request. I am not wxWidgets developer but I think there are to different UI solutions: - different tabs in output section like in SQL Workbench - different record sets like in MS (something like table of tables) I think it could be configured in options which approach is pr

Re: [pgadmin-support] feature request

2012-03-10 Thread Guillaume Lelarge
On Thu, 2012-03-08 at 11:37 +0100, unterrainer.guent...@leitwind.com wrote: > Thanks for your answers!! > > > > You can already to that by selecting the query you want to execute. > > People ask that we add a new way to execute queries so that it > executes > > the query where your cursor is but

Re: [pgadmin-support] feature request

2012-03-08 Thread Michael Shapiro
You're right. That complicates it. On Thu, Mar 8, 2012 at 6:43 AM, Dave Page wrote: > On Thu, Mar 8, 2012 at 12:26 PM, Michael Shapiro > wrote: > > SInce postgres would require a semi-colon between stmts, you could use > that > > fact to determine where a stmt starts and where it ends (even for

Re: [pgadmin-support] feature request

2012-03-08 Thread Guillaume Lelarge
On Thu, 2012-03-08 at 12:43 +, Dave Page wrote: > On Thu, Mar 8, 2012 at 12:26 PM, Michael Shapiro wrote: > > SInce postgres would require a semi-colon between stmts, you could use that > > fact to determine where a stamt starts and where it ends (even for the case > > when the last stmt doesn

Re: [pgadmin-support] feature request

2012-03-08 Thread Dave Page
On Thu, Mar 8, 2012 at 12:26 PM, Michael Shapiro wrote: > SInce postgres would require a semi-colon between stmts, you could use that > fact to determine where a stamt starts and where it ends (even for the case > when the last stmt doesn't have one) What if there's a semi colon in a comment, str

Re: [pgadmin-support] feature request

2012-03-08 Thread Michael Shapiro
SInce postgres would require a semi-colon between stmts, you could use that fact to determine where a stamt starts and where it ends (even for the case when the last stmt doesn't have one) On Thu, Mar 8, 2012 at 3:42 AM, Guillaume Lelarge wrote: > > On Thu, 2012-03-08 at 09:35 +0100, unterrainer

Re: [pgadmin-support] feature request

2012-03-08 Thread Guillaume Lelarge
Hi, On Thu, 2012-03-08 at 09:35 +0100, unterrainer.guent...@leitwind.com wrote: > A suggestion to this request: > I was used to work with TOAD on Oracle and there when you had more > statements in the editor (what you usually have), > when you executed then automatically only the statement where y

Re: [pgadmin-support] feature request

2012-03-07 Thread Guillaume Lelarge
On Wed, 2012-03-07 at 10:24 -0600, Michael Shapiro wrote: > Is is possible to have the results from multiple select statements be shown > in the SQL Editor? This is a TODO (http://code.pgadmin.org/trac/ticket/340). Unless someone is interested in working on a patch for this now (and has a great UI

[pgadmin-support] feature request

2012-03-07 Thread Michael Shapiro
Is is possible to have the results from multiple select statements be shown in the SQL Editor? You can run multiple, but only the results of the last one are currently shown.

Re: [pgadmin-support] feature request - show role members

2012-03-02 Thread Bartosz Dmytrak
Thanks for Your time :) hope this will help devs and admins Regards, Bartek 2012/3/2 Guillaume Lelarge > On Thu, 2012-03-01 at 08:06 -0600, Mike Blackwell wrote: > > > > On Wed, Feb 29, 2012 at 16:42, Guillaume Lelarge > > wrote: > > > > I understand, but we cannot put every way of vi

Re: [pgadmin-support] feature request - show role members

2012-03-02 Thread Guillaume Lelarge
On Thu, 2012-03-01 at 08:06 -0600, Mike Blackwell wrote: > > On Wed, Feb 29, 2012 at 16:42, Guillaume Lelarge > wrote: > > I understand, but we cannot put every way of visualizing a > database in > pgAdmin. This tool also needs to be simple to use, and having >

Re: [pgadmin-support] feature request - show role members

2012-02-29 Thread Guillaume Lelarge
On Tue, 2012-02-28 at 20:53 +0100, Bartosz Dmytrak wrote: > 2012/2/28 Guillaume Lelarge > On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > > Hi, > > I would like to see who is member of selected role, > somewhere in group role > > form. Hope this

Re: [pgadmin-support] feature request - show role members

2012-02-28 Thread Bartosz Dmytrak
2012/2/28 Guillaume Lelarge > On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > > Hi, > > I would like to see who is member of selected role, somewhere in group > role > > form. Hope this will help to administrate multiuser environments. > > > > This feature is covered by query: > > SEL

Re: [pgadmin-support] feature request - show role members

2012-02-28 Thread Guillaume Lelarge
On Tue, 2012-02-28 at 09:22 +0100, Bartosz Dmytrak wrote: > Hi, > I would like to see who is member of selected role, somewhere in group role > form. Hope this will help to administrate multiuser environments. > > This feature is covered by query: > SELECT p.rolname, m.rolname as member, g.rolname

[pgadmin-support] feature request - show role members

2012-02-28 Thread Bartosz Dmytrak
Hi, I would like to see who is member of selected role, somewhere in group role form. Hope this will help to administrate multiuser environments. This feature is covered by query: SELECT p.rolname, m.rolname as member, g.rolname as grantor FROM pg_authid p INNER JOIN pg_auth_members am ON (p.oid

Re: [pgadmin-support] Feature request: 'PG bin path' as Command Line Parameter

2012-02-17 Thread Guillaume Lelarge
On Fri, 2012-02-17 at 12:19 +0100, Jan-Peter Seifert wrote: > Hello, > > I often work with different major versions of PostgreSQL and prefer to use > the pg_dump version of the server. > > However, you can only set 'PG bin path' once for all versions of pgAdmin III. > So sometimes I forget to c

[pgadmin-support] Feature request: 'PG bin path' as Command Line Parameter

2012-02-17 Thread Jan-Peter Seifert
Hello, I often work with different major versions of PostgreSQL and prefer to use the pg_dump version of the server. However, you can only set 'PG bin path' once for all versions of pgAdmin III. So sometimes I forget to change the versions and the dump can't be restored without problems. So i

Re: [pgadmin-support] feature request - objects definition comparer

2012-01-22 Thread Guillaume Lelarge
On Tue, 2012-01-17 at 05:04 -0800, Francisco Leovey wrote: > I second the request > > IIRC, a GSoC worked on this, but we didn't have the time to do the remaining work to integrate it. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.po

Re: [pgadmin-support] Feature request: associate .sql extensions with pgAdmin III

2012-01-22 Thread Guillaume Lelarge
On Sat, 2012-01-14 at 16:19 -0600, Aren Cambre wrote: > Sorry for the lack of detail. > > I am using 1.14.1. It was bundled with Postgres 9.1.2. I am on Windows 7 > x64. > > For some reason, the pgAdmin III installer did not register .sql with > pgAdmin at all. I checked this by going to *Control

Re: [pgadmin-support] feature request - objects definition comparer

2012-01-17 Thread Francisco Leovey
I second the request From: "bdmyt...@eranet.pl" To: pgadmin-support@postgresql.org Sent: Tuesday, January 17, 2012 8:30 AM Subject: [pgadmin-support] feature request - objects definition comparer HI All, I think it is good idea to implem

[pgadmin-support] feature request - objects definition comparer

2012-01-17 Thread bdmyt...@eranet.pl
HI All, I think it is good idea to implement object comparer. It could be used to compare objects definitions in developer enviroment and production enviroment. Right now I need to manually extract definitions to separete sql files (or use pg_dump) and then comapre files with external tool. Inte

Re: [pgadmin-support] Feature request: associate .sql extensions with pgAdmin III

2012-01-14 Thread Aren Cambre
a proper answer. > It works fine for me with W7 and latest Pgadmin > > -- > *From:* Aren Cambre > *To:* pgadmin-support@postgresql.org > *Sent:* Saturday, January 14, 2012 12:48 AM > *Subject:* [pgadmin-support] Feature request: associate .sql

Re: [pgadmin-support] Feature request: associate .sql extensions with pgAdmin III

2012-01-14 Thread George Weaver
- Original Message - From: Aren Cambre To: pgadmin-support@postgresql.org Sent: Friday, January 13, 2012 9:48 PM Subject: [pgadmin-support] Feature request: associate .sql extensions with pgAdmin III On Windows systems, it sure would be nice if files with .sql extensions

Re: [pgadmin-support] Feature request: associate .sql extensions with pgAdmin III

2012-01-14 Thread Raymond O'Donnell
On 14/01/2012 03:48, Aren Cambre wrote: > On Windows systems, it sure would be nice if files with .sql extensions > automatically open in pgAdmin III when I double click on them. > > It appears that pgAdmin may not register *.sql* extension at all, as > even when I right-click and look at the *Ope

[pgadmin-support] Feature request: associate .sql extensions with pgAdmin III

2012-01-13 Thread Aren Cambre
On Windows systems, it sure would be nice if files with .sql extensions automatically open in pgAdmin III when I double click on them. It appears that pgAdmin may not register *.sql* extension at all, as even when I right-click and look at the *Open with* menu, I don't see pgAdmin III even listed.

Re: [pgadmin-support] feature request: displaying components of extension as gray.

2011-11-01 Thread Guillaume Lelarge
On Sun, 2011-10-30 at 07:46 +0100, pasman pasmański wrote: > Hi. > Extensions load sometimes big number of functions. > I think that they should be displayed as gray. > That won't lower the number of functions :) But, yes, we could probably display the functions' extensions another way. Another

[pgadmin-support] feature request: displaying components of extension as gray.

2011-10-29 Thread pasman pasmański
Hi. Extensions load sometimes big number of functions. I think that they should be displayed as gray. -- pasman -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] feature request

2011-09-09 Thread Guillaume Lelarge
On Sat, 2011-09-10 at 06:36 +0400, Dmitry MiksIr wrote: > 10.09.2011 0:46, Guillaume Lelarge пишет: > >> > >> Some combo (for example "Maintanance DB" in New Server dialog) allow to > >> type and select. May be switch "Data type" to this type of combo? > > This kind of combo has a sense for the mai

Re: [pgadmin-support] feature request

2011-09-09 Thread Dmitry MiksIr
10.09.2011 0:46, Guillaume Lelarge пишет: Some combo (for example "Maintanance DB" in New Server dialog) allow to type and select. May be switch "Data type" to this type of combo? This kind of combo has a sense for the maintenance DB. We have no list of the available databases. So, unless the u

Re: [pgadmin-support] feature request

2011-09-09 Thread Guillaume Lelarge
On Fri, 2011-09-09 at 23:29 +0400, Dmitriy MiksIr wrote: > > 08/30/2011 03:31 PM, Dave Page пишет: > > On Tue, Aug 30, 2011 at 11:56 AM, Tim Uckun wrote: > >> The drop down boxes in pgadmin don't have autocomplete and don't jump > >> to the items that start with the character you type. Most of t

Re: [pgadmin-support] feature request

2011-09-09 Thread Dmitriy MiksIr
08/30/2011 03:31 PM, Dave Page пишет: On Tue, Aug 30, 2011 at 11:56 AM, Tim Uckun wrote: The drop down boxes in pgadmin don't have autocomplete and don't jump to the items that start with the character you type. Most of them have a very long list of items in seemingly random order (function

Re: [pgadmin-support] feature request

2011-08-30 Thread Guillaume Lelarge
On Tue, 2011-08-30 at 20:42 +0100, Dave Page wrote: > On Tue, Aug 30, 2011 at 8:30 PM, Guillaume Lelarge > wrote: > > On Tue, 2011-08-30 at 19:29 +0100, Dave Page wrote: > >> On Tue, Aug 30, 2011 at 6:15 PM, Guillaume Lelarge > >> wrote: > >> >> > >> >> libpq doesn't support multiple resultsets i

Re: [pgadmin-support] feature request

2011-08-30 Thread Dave Page
On Tue, Aug 30, 2011 at 8:30 PM, Guillaume Lelarge wrote: > On Tue, 2011-08-30 at 19:29 +0100, Dave Page wrote: >> On Tue, Aug 30, 2011 at 6:15 PM, Guillaume Lelarge >> wrote: >> >> >> >> libpq doesn't support multiple resultsets in a single query unfortunately. >> >> >> > >> > As a matter of fac

Re: [pgadmin-support] feature request

2011-08-30 Thread Guillaume Lelarge
On Tue, 2011-08-30 at 19:29 +0100, Dave Page wrote: > On Tue, Aug 30, 2011 at 6:15 PM, Guillaume Lelarge > wrote: > >> > >> libpq doesn't support multiple resultsets in a single query unfortunately. > >> > > > > As a matter of fact, it does (see > > http://pgolub.wordpress.com/2009/11/17/script-sl

Re: [pgadmin-support] feature request

2011-08-30 Thread Dave Page
On Tue, Aug 30, 2011 at 6:15 PM, Guillaume Lelarge wrote: >> >> libpq doesn't support multiple resultsets in a single query unfortunately. >> > > As a matter of fact, it does (see > http://pgolub.wordpress.com/2009/11/17/script-slicing-by-pgmdd/), and I > really want pgAdmin to use this. Still nee

Re: [pgadmin-support] feature request

2011-08-30 Thread Guillaume Lelarge
On Tue, 2011-08-30 at 12:31 +0100, Dave Page wrote: > On Tue, Aug 30, 2011 at 11:56 AM, Tim Uckun wrote: > > The drop down boxes in pgadmin don't have autocomplete and don't jump > > to the items that start with the character you type. Most of them > > have a very long list of items in seemingly

Re: [pgadmin-support] feature request

2011-08-30 Thread Dave Page
On Tue, Aug 30, 2011 at 11:56 AM, Tim Uckun wrote: > The drop down boxes in pgadmin don't have autocomplete and don't jump > to the items that start with the character you type.  Most of them > have a very long list of items in seemingly random order (function > return types for example) so an aut

[pgadmin-support] feature request

2011-08-30 Thread Tim Uckun
The drop down boxes in pgadmin don't have autocomplete and don't jump to the items that start with the character you type. Most of them have a very long list of items in seemingly random order (function return types for example) so an autocomplete would make this a lot easier to use. Also while I

Re: [pgadmin-support] Feature request: copy and quotes

2011-08-30 Thread Colin Beckingham
On 08/27/2011 11:46 PM, Fernando Hevia wrote: Not sure if available in v1.12 but in 1.14 you can change the quote character at your leisure from File -> Options -> Query tool -> "Result copy quote character". Cheers. On Sat, Aug 27, 2011 at 10:58, Colin Beckingham mailto:col...@start.ca>> wrote

Re: [pgadmin-support] Feature request: Select All in Query Builder

2011-08-29 Thread Guillaume Lelarge
On Sat, 2011-08-27 at 16:25 -0500, Aren Cambre wrote: > Feature request In Query Builder, when I add a relation to the design > surface, all columns are unchecked. I'd like a way I can check or uncheck > all items in the relation. Currently, the only way I can intuit to do this > is to manually cli

Re: [pgadmin-support] Feature request: copy and quotes

2011-08-28 Thread Guillaume Lelarge
On Sun, 2011-08-28 at 00:46 -0300, Fernando Hevia wrote: > Not sure if available in v1.12 but in 1.14 you can change the quote > character at your leisure from File -> Options -> Query tool -> "Result copy > quote character". > It was already available in previous releases. -- Guillaume http

Re: [pgadmin-support] Feature request: copy and quotes

2011-08-27 Thread Fernando Hevia
Not sure if available in v1.12 but in 1.14 you can change the quote character at your leisure from File -> Options -> Query tool -> "Result copy quote character". Cheers. On Sat, Aug 27, 2011 at 10:58, Colin Beckingham wrote: > Using Opensuse 11.4 Kernel 3.0, pgadmin 1.12.3 > > In the query too

[pgadmin-support] Feature request: Select All in Query Builder

2011-08-27 Thread Aren Cambre
Feature request In Query Builder, when I add a relation to the design surface, all columns are unchecked. I'd like a way I can check or uncheck all items in the relation. Currently, the only way I can intuit to do this is to manually click every check box. Aren Cambre

[pgadmin-support] Feature request: copy and quotes

2011-08-27 Thread Colin Beckingham
Using Opensuse 11.4 Kernel 3.0, pgadmin 1.12.3 In the query tool, ctrl-C from a highlighted record in a result set produces a string which quotes strings with double quotes. Postgresql does not seem to like double quotes in, say, insert requests, so when you build a new insert request by pasting t

Re: [pgadmin-support] Feature request: autosave for Query Tool

2011-08-26 Thread Guillaume Lelarge
On Fri, 2011-08-26 at 20:20 +0100, Dave Page wrote: > On Fri, Aug 26, 2011 at 8:09 PM, Josh Berkus wrote: > > Despite the improvements, pgAdmin is still a bit crashy on Mac. I think > > this will continue to be the case for some releases to come. > > Really? I use it every day and don't recall t

Re: [pgadmin-support] Feature request: autosave for Query Tool

2011-08-26 Thread Dave Page
On Fri, Aug 26, 2011 at 8:09 PM, Josh Berkus wrote: > Despite the improvements, pgAdmin is still a bit crashy on Mac.  I think > this will continue to be the case for some releases to come. Really? I use it every day and don't recall the last time I saw a crash that wasn't caused by development c

[pgadmin-support] Feature request: autosave for Query Tool

2011-08-26 Thread Josh Berkus
Despite the improvements, pgAdmin is still a bit crashy on Mac. I think this will continue to be the case for some releases to come. In the meantime, it would be useful if we could define an autosave interval for query windows. Currently, losing hours of SQL tinkering work when pgadmin crashes u

Re: [pgadmin-support] Feature request: Allow Grant Wizard at lower level

2011-04-17 Thread Guillaume Lelarge
Le 14/04/2011 15:12, Aren Cambre a écrit : > If I have multiple schemas, it appears I have to run the Grant Wizard once > per schema. Please allow the Grant Wizard to run at a lower level, such as > on the Schemas item or on the database item, to allow me to run the Grant > Wizard once for all appl

[pgadmin-support] Feature request: Allow Grant Wizard at lower level

2011-04-14 Thread Aren Cambre
If I have multiple schemas, it appears I have to run the Grant Wizard once per schema. Please allow the Grant Wizard to run at a lower level, such as on the Schemas item or on the database item, to allow me to run the Grant Wizard once for all applicable items in a database. Aren

Re: [pgadmin-support] Feature request: ability to set hostaddr

2011-04-02 Thread Guillaume Lelarge
Le 12/03/2011 10:37, Guillaume Lelarge a écrit : > Le 06/03/2011 12:15, Christopher Head a écrit : >> On Sat, 05 Mar 2011 20:30:42 +0100 >> Guillaume Lelarge wrote: >> >>> Hi, >>> >>> Le 02/03/2011 07:45, Christopher Head a écrit : [...] I'd like to request the ability to set hostaddr se

Re: [pgadmin-support] Feature Request: SQL parameters

2011-03-19 Thread Bernhard Neuhauser
Hi, > Ok, but the use-case I'm talking about is debugging applications using > SQL, in my case an application using JDBC. Maybe I'm misunderstanding > the point of your post. I'm taking it as suggesting I switch to using $n > notation. This isn't an option. If you are using hibernate (which is

Re: [pgadmin-support] Feature Request: SQL parameters

2011-03-19 Thread Pavel Stehule
2011/3/19 Eric Schwarzenbach : > On 3/19/2011 1:52 PM, Pavel Stehule wrote: >> >> 2011/3/19 Eric Schwarzenbach: >>> >>> On 3/19/2011 12:21 PM, Pavel Stehule wrote: 2011/3/19 Eric Schwarzenbach: > > On , Sat, 05 Mar 2011 20:39:53 +0100, Guillaume wrote >> >> Le 03/03/2011 0

Re: [pgadmin-support] Feature Request: SQL parameters

2011-03-19 Thread Eric Schwarzenbach
On 3/19/2011 1:52 PM, Pavel Stehule wrote: 2011/3/19 Eric Schwarzenbach: On 3/19/2011 12:21 PM, Pavel Stehule wrote: 2011/3/19 Eric Schwarzenbach: On , Sat, 05 Mar 2011 20:39:53 +0100, Guillaume wrote Le 03/03/2011 00:03, Eric Schwarzenbach a écrit : Some years ago I worked with another DB

Re: [pgadmin-support] Feature Request: SQL parameters

2011-03-19 Thread Pavel Stehule
2011/3/19 Eric Schwarzenbach : > On 3/19/2011 12:21 PM, Pavel Stehule wrote: >> >> 2011/3/19 Eric Schwarzenbach: >>> >>> On , Sat, 05 Mar 2011 20:39:53 +0100, Guillaume wrote Le 03/03/2011 00:03, Eric Schwarzenbach a écrit : > >  Some years ago I worked with another DB tool, for a

  1   2   3   >