Re: [pgadmin-support] feture request

2010-02-08 Thread Guillaume Lelarge
Le 31/01/2010 17:44, Little, Douglas a écrit : > Guillaume, > Looks great. I think people will really like it. > Thanks for all the hard work. > > Cheers! > Doug > > > -Original Message- > From: Guillaume Lelarge [mailto:guilla...@lelarge.info] > Sent: Sunday, January 31, 2010 10:04

Re: [pgadmin-support] Controlling Server status log download

2010-02-08 Thread Guillaume Lelarge
Le 07/02/2010 17:40, Little, Douglas a écrit : > Morning, > You guys are great! I love the responsiveness. So much better than we get > from our paid vendor. > > The Dba is setting log to 200meg. So, yes it's still a lot to download. > > I'd like to see a function that would disable the l

Re: [pgadmin-support] a quick question

2010-02-08 Thread Guillaume Lelarge
Le 05/02/2010 18:06, Farrer, Rhys a écrit : > [...] > > I have installed PostgreSQL 8.4 on my mac osX. Is there a postgresql-libs > package that i can install? I can only seem to find those made for unix. > I really don't know. You should better ask on the pgsql-general list. -- Guillaume.

Re: [pgadmin-support] Table size

2010-02-08 Thread Guillaume Lelarge
Le 05/02/2010 11:57, Greg Smith a écrit : > Benjamin Krajmalnik wrote: >> >> In pgAdmin, one can view the total disk size occupied by a table in >> the statistics view when in the “Tables” context. >> >> What query is being used to calculate this? >> >> I have found pg_relation_size() but it has to

Re: [pgadmin-support] how to view TOAST table

2010-02-08 Thread Guillaume Lelarge
Hi, Le 05/02/2010 06:50, Abhisekh Mohapatro a écrit : > [...] > I have a table which has a column with datatype BYTEA. > In order to trigger TOAST mechanism for the column, I have made the following > alteration. > > ALTER TABLE table_name ALTER COLUMN column_name SET STORAGE EXTERNAL > I adde