From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "ow" <oneway_111(at)yahoo(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Large tables, copy-and-paste, default sql |
Date: | 2003-11-10 08:44:33 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B84C5D58@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: ow [mailto:oneway_111(at)yahoo(dot)com]
> Sent: 09 November 2003 15:06
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Large tables, copy-and-paste, default sql
>
> pgAdmin III, v1.0.0, pgSql 7.4.rc1
>
> Hi,
>
> Thanks for the great product, it really helps!
>
> There a couple of things that, I think, could be improved still:
>
> 1. Tree view that shows the list of tables: When I click on a
> table that contains relatively large number of rows (20M+),
> it takes pgAdmin a very, very long time to show the
> respective CREATE clause for the table. It appears that
> pgAdmin is forcing pgSql to count rows in the table, though I
> may be wrong. Is there a way to avoid the delay?
pgAdmin checks the estimated row count before actually counting rows.
You can set the threshold that will prevent counting under
Tools->Options.
> 2. pgAdmin Query/Sql tool: It'd be nice if there was a way to
> copy data from the "data output" tab. I know it can be
> exported, but many times I need just a small piece of data
> and it'd be nice to just copy-and-paste.
You can copy individual values using the normal keysequences such as
Control-C for copy. Currently you cannot select regions of cells for
copy/paste - I'm not sure how feasible this is right now, though I can
see the usefullness of it.
>
> 3. pgAdmin Query/Sql tool: IMHO, it be better if Sql/Query
> tool window opened blank, i.e. without prepopulating it with
> SQL of the item that had focus when Query tool was launched.
> Most of the time (99%), I remove default SQL, it does not do
> me any good.
There is an option to prevent this under Tools->Options.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Дмитрий Попов | 2003-11-10 08:55:14 | Bug |
Previous Message | Reshat Sabiq | 2003-11-09 20:51:53 | Re: RE |