Re: [pgadmin-support] datestyle issue. Is it always set to ISO, DMY ?

2010-05-19 Thread Ermengol Bota 
2010/5/19 Guillaume Lelarge :
> Le 19/05/2010 00:15, Ermengol Bota a écrit :
> ...
>> But, if you are on the query tool you can change this behaviour with
>> (for example)
>> set datestyle = "postgres, euro";
>>
>> and then if you select a column with dates they will formatted the european 
>> way
>> dd-mm-
>> ...
>
> Sure, you bypassed pgAdmin session configuration, so pgAdmin displayed
> dates in the datestyle you specified on the session.
>
> pgAdmin got a result from PostgreSQL and it displays it in the same way.
> It doesn't change the string it receives. It displays ISO by default
> because, when it connects to a database, the first query it launches is
> a "SET DateStyle=ISO;". It'll display with another style if you changes
> the DateStyle parameter of the session.


First of all, thank you  for your fast answer and clear explanations.
Second :-), I'm not a database administrator, I'm just a teacher on a
software engineering subject at the university where we use postgres.
So, you are the experts, and probably the real users :-)

But, there is one thing that I don't understand.
I agree that is a good convention to force the datestyle wherever
pgadmin is running (even though when using a JDBC connection it
usually sets datestyle according to the SO locale or the one indicated
in the connection string), this way, pgadmin will always show the
dates the same way. Ok, no problem :-)

But, as far as you can set DataStyle variable for each database, maybe
could be a good idea that when connecting to a database that has this
variable setted not to "overwrite" it with the default (ISO).

( ALTER DATABASE aDtabase SET DateStyle='postgres, euro'; )


The idea is that if a database has the variable datestyle setted use
it, otherwise use ISO

Well, it's just an opinion :-)

And thanks for this great tool!

-- 
* Ermengol *
*
* Els ordinadors no resolen problemes, *
* simplement executen solucions   *
*

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] Query results grid copy header

2010-05-19 Thread Little, Douglas 
Hi,

When I copy/paste to excel the query results grid I'm not getting the column 
headers.  Is there any option to have the headers copied?

Thanks


Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 
312.894.5164 | Cell 847-997-5741
douglas.lit...@orbitz.com
 [cid:image001.jpg@01CAF736.80731200]   orbitz.com | 
ebookers.com | 
hotelclub.com | 
cheaptickets.com | 
ratestogo.com | 
asiahotels.com

<>

[pgadmin-support] Subqueries in Graphical Query Builder?

2010-05-19 Thread Forrest Cahoon 
I find myself using the Graphical Query Builder more and more, but the
one thing I wish it had is support for subqueries.  Are there any
plans to add that feature?

Forrest

-- 
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] Query results grid copy header

2010-05-19 Thread Guillaume Lelarge 
Le 19/05/2010 16:34, Little, Douglas a écrit :
> Hi,
> 
> When I copy/paste to excel the query results grid I'm not getting the column 
> headers.  Is there any option to have the headers copied?
> 

I don't think we have that. Didn't find it anyway. So I added a ticket
(http://code.pgadmin.org/trac/ticket/190) so that we can work on it later.

Thanks.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

-- 
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] Subqueries in Graphical Query Builder?

2010-05-19 Thread Guillaume Lelarge 
Le 19/05/2010 18:21, Forrest Cahoon a écrit :
> I find myself using the Graphical Query Builder more and more, but the
> one thing I wish it had is support for subqueries.  Are there any
> plans to add that feature?
> 

Nope. AFAICT, there are no plans on the GQB right now. Moreover I don't
see how we could do that (in a UI way, I mean).


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

-- 
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] Subqueries in Graphical Query Builder?

2010-05-19 Thread Forrest Cahoon 
On Wed, May 19, 2010 at 2:43 PM, Guillaume Lelarge
 wrote:
> Le 19/05/2010 18:21, Forrest Cahoon a écrit :
>> I find myself using the Graphical Query Builder more and more, but the
>> one thing I wish it had is support for subqueries.  Are there any
>> plans to add that feature?
>>
>
> Nope. AFAICT, there are no plans on the GQB right now. Moreover I don't
> see how we could do that (in a UI way, I mean).

Here's how I thought it might work:

When you go to the criteria tab and click the "+" button, you get a
Set Value dialog box which comes up. Currently this gives you a tree
view of the tables you've joined, from which you can select a column.
A subquery button could be added to that dialog, which would bring up
a new query builder window (or create another tab at the top along
with "SQL Editor" and "Graphical Query Builder");

I'm sure there are a lot of details which would have to be worked out, though.

Forrest

-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support