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
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 (..
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
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
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
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
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
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
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
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
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
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
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
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
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
>
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
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
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
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
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'
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
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
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.
> > >
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
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
>
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
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
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
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
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
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
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 implement object compare
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 Panel* >
*Programs* > *Default
Programs* > *Set Associations* (thes
- 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
automatica
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 another DB that
offered support for SQL parameters in a way th
>>
>
> using $n notation can be more faster and simpler for implementation -
> and practic, because programmer can check a prepared statements or
> parametrised queries in pgAdmin.
>
and there is a parser's hook that support searching a parameters in query.
Regards
Pavel Stehule
--
Sent via pg
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 another DB that
>> > offered support for SQL parameters in a way that was extremely handy.
>> > I'
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 another DB that
> offered support for SQL parameters in a way that was extremely handy.
> I've missed this feature in pgAdmin ever since.
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 separately from host
>>> when creating a server connection.
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 separately from host
> > when creating a server connection. This is currently impossible.
>
> Could you remind me w
On Sat, Mar 5, 2011 at 20:39, Guillaume Lelarge wrote:
> I'm not sure I understand what you would like to have. That pgAdmin asks
> for values anytime it encounters a question mark in a query?
>
Yes, and I would really like that, too. As well as named parameters and
things like $1.
Look how fun p
Le 03/03/2011 00:03, Eric Schwarzenbach a écrit :
> Some years ago I worked with another DB tool, for another DB that
> offered support for SQL parameters in a way that was extremely handy.
> I've missed this feature in pgAdmin ever since. By SQL parameters, I
> mean the replaceable bits one puts a
Hi,
Le 02/03/2011 07:45, Christopher Head a écrit :
> [...]
> I'd like to request the ability to set hostaddr separately from host
> when creating a server connection. This is currently impossible.
Could you remind me why this would be interesting? AFAIR, they are
pretty much the same thing, aren
Hi,
Yes, I would also appreciate if one could connect to a service defined
in pg_service.conf
I just recently discovered the possibility to define postgres services
- though I have been told it had been around for years ...
Andreas
On Tue, 1 Mar 2011 22:45:44 -0800, Christopher Head wrote:
Le 06/01/2011 12:02, Grazvydas Valeika a écrit :
>
>> Yeah, this is something we would like to have. Probably displaying the
>> beginning of the string, and then an ellipsis. And you will have the
>> complete content in another window. But we need to find time to work on
>> this.
>>
>> Thanks for
Yeah, this is something we would like to have. Probably displaying the
beginning of the string, and then an ellipsis. And you will have the
complete content in another window. But we need to find time to work on
this.
Thanks for your request.
This would be great. But to be real, for newbie li
Le 06/01/2011 10:01, Grazvydas Valeika a écrit :
> [...]
> I would like to have an opportunity to see that content of query result
> cell is too long to display.
>
> F.e. situation:
> I have query with array_agg function in one column. Most of rows bring
> up to 20 values, some ~100, only one row
On 17/11/2010 11:22, Dan Shoubridge wrote:
Dan,
Ok, I understand and it's a shame the vars aren't strong typed. It's
little things like that that make me want SQL Server back. It doesn't seem
like a big thing to some people, but for a lot of developers the amount of
work added by this when debug
>>Dan,
>> Ok, I understand and it's a shame the vars aren't strong typed. It's
little things like that that make me want SQL Server back. It doesn't seem
like a big thing to some people, but for a lot of developers the amount of
work added by this when debugging sql adds up over time.
>I know it'
Dan,
> Ok, I understand and it's a shame the vars aren't strong typed. It's
little things like that that make me want SQL Server back. It doesn't seem
like a big thing to some people, but for a lot of developers the amount of
> work added by this when debugging sql adds up over time.
I know it'
On Wed, Nov 17, 2010 at 9:40 AM, Dan Shoubridge
wrote:>
>
> Ok, I understand and it’s a shame the vars aren’t strong typed. It's little
> things like that that make me want SQL Server back. It doesn't seem like a
> big thing to some people, but for a lot of developers the amount of work
> added by
>Le 16/11/2010 23:26, Guillaume Lelarge a écrit :
>> Le 16/11/2010 14:01, Dan Shoubridge a écrit :
>> Originally from SQL Server background, there is one feature that I
>> am missing and would save developers hours of time.
>>
>> In SQL Server I could copy sql code out of an applic
Le 16/11/2010 23:26, Guillaume Lelarge a écrit :
> Le 16/11/2010 14:01, Dan Shoubridge a écrit :
> Originally from SQL Server background, there is one feature that I
> am missing and would save developers hours of time.
>
> In SQL Server I could copy sql code out of an application
Le 16/11/2010 14:01, Dan Shoubridge a écrit :
Originally from SQL Server background, there is one feature that I
am missing and would save developers hours of time.
In SQL Server I could copy sql code out of an application and
paste it into SSMS, declare & assign vars tha
> > > Originally from SQL Server background, there is one feature that I
> > > am missing and would save developers hours of time.
> > >
> > > In SQL Server I could copy sql code out of an application and
> > > paste it into SSMS, declare & assign vars that exist in the sql
> > > and run - grea
> > Le 16/11/2010 13:14, Dan Shoubridge a écrit :
> > > Originally from SQL Server background, there is one feature that I
> > > am missing and would save developers hours of time.
> > >
> > > In SQL Server I could copy sql code out of an application and paste
> > > it into SSMS, declare & assig
Le 16/11/2010 13:34, Guillaume Lelarge a écrit :
> Le 16/11/2010 13:14, Dan Shoubridge a écrit :
>> Originally from SQL Server background, there is one feature that I am
>> missing and would save developers hours of time.
>>
>> In SQL Server I could copy sql code out of an application and paste it
Le 16/11/2010 13:14, Dan Shoubridge a écrit :
> Originally from SQL Server background, there is one feature that I am
> missing and would save developers hours of time.
>
> In SQL Server I could copy sql code out of an application and paste it into
> SSMS, declare & assign vars that exist in the s
I think trying to do this in the query tool (with arbitrary selects) is
problematic.
All I really am asking for is that the edit grid be able to produce the
inserts based on the data it has displayed in the grid.
On Wed, Oct 27, 2010 at 9:29 AM, Thom Brown wrote:
> On 27 October 2010 14:08, Jul
On 27 October 2010 14:08, Julius Tuskenis wrote:
> 2010.10.27 15:22, Michael Shapiro rašė:
>>
>> Thom Brown has it basically right. I want to be able to take the results
>> of what is in the grid editor and produce insert stmts.
>
> Yes - this kind of tool would be handy in situation when while de
2010.10.27 15:22, Michael Shapiro rašė:
Thom Brown has it basically right. I want to be able to take the
results of what is in the grid editor and produce insert stmts.
Yes - this kind of tool would be handy in situation when while
developing applications one uses pgAdmin and later there is a ne
My apologies. I had sent email to this list last Feb with this request
It would be very useful to be able to export the results of a query as
select into statements, at least in the case when there is only one table in
the from clause.
I didn't get a reply, so I thought I was asking on the wrong
1 - 100 of 178 matches
Mail list logo
