On Thu, 2012-09-13 at 22:09 +0200, Bartosz Dmytrak wrote:
> Hi All
> Today I decided to build a query using Query Builder functionality of
> pgAdmin, so I switched to Graphical Query Builder tab and did
> some clicking Few seconds later I received something like this:
>
> SELECT
> jpga_servergr
Hi All
Today I decided to build a query using Query Builder functionality of
pgAdmin, so I switched to Graphical Query Builder tab and did
some clicking Few seconds later I received something like this:
SELECT
jpga_servergroups.groupid,
jpga_servergroups.groupname,
jpga_servergroups.caption
On Thu, Sep 23, 2010 at 9:34 PM, Guillaume Lelarge
wrote:
> Le 23/09/2010 22:31, Dave Page a écrit :
>> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz wrote:
>>> Hi All,
>>> I have a minor grievance with pgAdmin3's Graphical Query Builder.
>>> I click plus on Schemas, then public has no plus, so I
From: Guillaume Lelarge
> Le 23/09/2010 22:37, Thom Brown a écrit :
>> On 23 September 2010 21:31, Dave Page wrote:
>>> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz wrote:
Hi All,
I have a minor grievance with pgAdmin3's Graphical Query Builder.
I click plus on Schemas, then publi
Le 23/09/2010 22:48, Magnus Hagander a écrit :
> On Thu, Sep 23, 2010 at 22:44, Guillaume Lelarge
> wrote:
>> Le 23/09/2010 22:37, Thom Brown a écrit :
>>> On 23 September 2010 21:31, Dave Page wrote:
On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz wrote:
> Hi All,
> I have a minor gr
On Thu, Sep 23, 2010 at 22:44, Guillaume Lelarge wrote:
> Le 23/09/2010 22:37, Thom Brown a écrit :
>> On 23 September 2010 21:31, Dave Page wrote:
>>> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz wrote:
Hi All,
I have a minor grievance with pgAdmin3's Graphical Query Builder.
I c
Le 23/09/2010 22:37, Thom Brown a écrit :
> On 23 September 2010 21:31, Dave Page wrote:
>> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz wrote:
>>> Hi All,
>>> I have a minor grievance with pgAdmin3's Graphical Query Builder.
>>> I click plus on Schemas, then public has no plus, so I must double
On 23 September 2010 21:31, Dave Page wrote:
> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz wrote:
>> Hi All,
>> I have a minor grievance with pgAdmin3's Graphical Query Builder.
>> I click plus on Schemas, then public has no plus, so I must double click
>> public, then the plus button appears, w
Le 23/09/2010 22:31, Dave Page a écrit :
> On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz wrote:
>> Hi All,
>> I have a minor grievance with pgAdmin3's Graphical Query Builder.
>> I click plus on Schemas, then public has no plus, so I must double click
>> public, then the plus button appears, which
On Thu, Sep 23, 2010 at 9:27 PM, Peter Dietz wrote:
> Hi All,
> I have a minor grievance with pgAdmin3's Graphical Query Builder.
> I click plus on Schemas, then public has no plus, so I must double click
> public, then the plus button appears, which I can then click to expand the
> list to see wh
Hi All,
I have a minor grievance with pgAdmin3's Graphical Query Builder.
I click plus on Schemas, then public has no plus, so I must double click
public, then the plus button appears, which I can then click to expand the
list to see whats in my database.
[-] my-database-name
[+] Catalogs
Le 15/03/2010 09:54, Julius Tuskenis a écrit :
> [...]
> I don't usually use the builder, but sometimes it is convenient for long
> table/column names having queries. I'd like to propose some improvements
> to it:
> 1. Why not join the selected tables if they are related over foreign
> key? Usually
Hello,
I don't usually use the builder, but sometimes it is convenient for long
table/column names having queries. I'd like to propose some improvements
to it:
1. Why not join the selected tables if they are related over foreign
key? Usually well designed database uses FK to keep relations in
Le 21/02/2010 17:10, Fernando Hevia a écrit :
> Well... I don't use it either. The only place I have used anything like a
> graphical query builder (or wizard) was in MS Access, but thats just because
> of the crazy sql syntax that thing has.
>
I don't use it either. But it doesn't mean we don't
1, 2010 4:49 AM
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Graphical Query Builder - usage stats?
>
>
> I'm wondering how many people is actually using Graphical
> Query Builder.
>
> Coming from MSSQL (last version used was MSSQL2000), with it&#x
I don't use it. I think it might be useful for a user that is not familiar
with the database. I would use auto-complete more if it would complete
column names, but it only seems to complete schemas/tables/views. So in the
end, I just type it all in.
On Sun, Feb 21, 2010 at 6:48 AM, Mario Splival
Hy,
I work with multiple sql windows but some times for complex query that
join multiple tables, I use the query designer for selecting the table
an the appropriate join.
Then the aggregate, restrictions and projections are build only in
text.
What is amazing is that for jasperreport, I work on
Well... I don't use it either. The only place I have used anything like a
graphical query builder (or wizard) was in MS Access, but thats just because
of the crazy sql syntax that thing has.
Instead of the query builder feature I rather had many sql window tabs.
Cheers.
On Sun, Feb 21, 2010 at 0
I'm wondering how many people is actually using Graphical Query Builder.
Coming from MSSQL (last version used was MSSQL2000), with it's
Enterprise Manager and Query Builder... I never used it. I always found
it much easier/faster to type the query in Query Analyzer - as I'm doing
today, using
You may need to double click on the schema..
That should populate the tables & view.
On Fri, Feb 12, 2010 at 9:25 PM, Tyler Erickson wrote:
> I am trying out the Graphic Query Builder for the first time, but I am
> unable to view any tables in the object tree for the database. The
> public schem
I am trying out the Graphic Query Builder for the first time, but I am
unable to view any tables in the object tree for the database. The
public schema is shown, but no tables appear underneath it. Do certain
permission need to be set in order for the tables to appear ?
environment: pgadmin3 1.1
Applies to PgAdmin 1.10.0, PostGIS (in general)
When working with geodata (using PostGIS in PostgreSQL) its often
neccessary to make joins that are not regular joins (see the example
below), and use all kinds of special processing functions. It is not
possible to enter them in the graphical que
Le dimanche 2 août 2009 à 17:58:58, Jason Felds a écrit :
> Is there any way to make the Graphical Query Builder use JOIN syntax
> when linking two tables together instead of WHERE? I personally find
> JOIN to be cleaner.
>
AFAIK, there's none. Could be interesting to add as an option.
--
Guil
Is there any way to make the Graphical Query Builder use JOIN syntax
when linking two tables together instead of WHERE? I personally find
JOIN to be cleaner.
Jason Felds
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://ww
On Wed, Apr 8, 2009 at 12:54 PM, valgog wrote:
> It would be really nice to make it possible to add a possibility to
> disable the usage of 'Graphical Query Builder' (or at least add an
> additional confirmation dialog before switching to this mode)
>
> The problem is, that when Graphical Query Bu
It would be really nice to make it possible to add a possibility to
disable the usage of 'Graphical Query Builder' (or at least add an
additional confirmation dialog before switching to this mode)
The problem is, that when Graphical Query Builder is trying to fetch
schemas and tables for that curr
26 matches
Mail list logo
