Re: Large tables, copy-and-paste, default sql

> -----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.