2012/3/18 Guillaume Lelarge
> Le 14/03/2012 21:43, Bartosz Dmytrak a écrit :
>
> As I wrote, SQL Workbench is good benchmark - it is not possible to
>> select columns without named table, again, there is even possibility to
>> filter list of available elements (tables, views, columns,...).
>> In
Le 14/03/2012 21:43, Bartosz Dmytrak a écrit :
As I wrote, SQL Workbench is good benchmark - it is not possible to
select columns without named table, again, there is even possibility to
filter list of available elements (tables, views, columns,...).
In my opinion GUI tool should support this fea
As I wrote, SQL Workbench is good benchmark - it is not possible to select
columns without named table, again, there is even possibility to filter
list of available elements (tables, views, columns,...).
In my opinion GUI tool should support this feature (with or without psql
background). This spee
On Wed, Mar 14, 2012 at 3:04 PM, David Greco
wrote:
> Let me voice my agreement for this as a feature sorely missing from pgAdmin.
> Should be able to do full code completion of column names (aliased or not
> table names), function names (type schema. and functions should be available
> as a compl
displays a list
of the parameters for that function).
From: pgadmin-support-ow...@postgresql.org
[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Bartosz Dmytrak
Sent: Tuesday, March 13, 2012 5:56 PM
To: Guillaume Lelarge
Cc: PgAdmin Support
Subject: Re: [pgadmin-support] code
Hi,
lets say I would like do write something like this:
SELECT a."Col1", b."Col2"
FROM "FirstSchema"."FirstTable" a
INNER JOIN "SecondSchema"."SecondTable" b ON (a."RowId" = b."RefRowId")
WHERE a."Col3" = NULL;
so:
what works for me (pseudo code):
SELECT
FROM list of schemas in context menu the
On Tue, 2012-03-13 at 22:30 +0100, Bartosz Dmytrak wrote:
> Hi all,
> there is code completion feature in pgAdmin, where can I found some doc to
> read about this?
IIRC, the code completion feature comes from psql.
> It is great thing, but looks like need more development - on first sight
> e.g.
Hi all,
there is code completion feature in pgAdmin, where can I found some doc to
read about this?
It is great thing, but looks like need more development - on first sight
e.g. I can't discover how to get column names, how to accept schema
selection (without using space).
thanks in advance
Regar