Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 23 October 2003 11:51 > To: Dave Page > Cc: Constantin Stefanov; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Very slow viewing of large table. > > Dave Page wrote: > > > > > > > > > > >>-Origina

Re: [pgadmin-support] Execute TO in PgadminIII

2003-10-23 Thread Andreas Pflug
Tino Wildenhain wrote: Very sexy would be this: http://www.python.org/doc/current/ext/embedding.html So we would be able to develop a zillon of plugins for every platform - just as a script hook for pgAdmin :-) Yes, Python *is* sexy, it's my first choice. We certainly shouldn't reinvent the whee

Re: [pgadmin-support] EXPORT from Query Tool

2003-10-23 Thread Andreas Pflug
was: Execute TO in PgadminIII Tino Wildenhain wrote: Re: [pgadmin-support] EXPORT from Query Tool (was: Execute TO in PgadminIII) But simple HTML would do the trick for Excel and even OpenOffice can read this: column1column2 ... and so on. We can have multiple export formats, of course.

Re: [pgadmin-support] German umlauts in pgadmin III

2003-10-23 Thread Andreas Pflug
Albin Blaschka wrote: Hello, Thanks for all the answers, I solved the problem with "converting" my databases to Latin1... (dumping the data, dropping the DB, recreate it with Latin1, reloading data) Was quite an effort, but did it and without problems... BTW: PGAdmin III, V1.01 did *not* work in

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Constantin Stefanov [mailto:[EMAIL PROTECTED] Sent: 23 October 2003 08:59 To: [EMAIL PROTECTED] Subject: Re: [pgadmin-support] Very slow viewing of large table. SELECT relname, reltuples FROM pg_class; For my table there is -

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Dave Page
> -Original Message- > From: Constantin Stefanov [mailto:[EMAIL PROTECTED] > Sent: 23 October 2003 08:59 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Very slow viewing of large table. > > > SELECT relname, reltuples FROM pg_class; > For my table there is > -

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Constantin Stefanov
Dave Page wrote: Thanks, I set that value to 0, and now I have the desired behaviour. But, for that table the values are: Rows(estimated) - 7 Rows(counted) - 77204608 I think the difference is too large. From the debug output I could not understand the query which pg_admin issues to have the val

Re: [pgadmin-support] Very slow viewing of large table.

2003-10-23 Thread Dave Page
> -Original Message- > From: Constantin Stefanov [mailto:[EMAIL PROTECTED] > Sent: 23 October 2003 07:30 > To: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Very slow viewing of large table. > > Thanks, I set that value to 0, and now I have the desired behaviour. > But, for that t