Re: [GENERAL] Admin / client tools for Win32?

In my RedHat 6.0 , it already have pgaccess.
I think when you install postgres 6.4 ( or later ) , you may already have it.

Courtney Thomas wrote:

> Greetings !
>
> Where can I get info on "pgaccess" ?
>
> Thanks,
>
> Courtney
>
> -------------------------------------------------------------
>
> Thomas Antepoth wrote:
> >
> > Hi Mat,
> >
> > On Tue, 28 Dec 1999, Matthew Brown wrote:
> >
> > > I have a web hosting client who wants SQL support, and is very used
> > > to using MSAccess with MS SQL Server with all the integration they have.
> >
> > read: incompatibility in means of cross platform environments.
> >
> > > Can anyone point me to good GUI Win32 tools for manipulating Postgres?
> > > Mostly what would be needed are database diagramming tools, etc.,
> > > but admin tools would be great, too.
> >
> > You might try using the ODBC Driver kit for Postgres.
> > It performs well and it does the trick connecting a WIN32
> > Application to a Postgres Server.
> >
> > One pitfall still exists: If you don愒 define your
> > Primary keys well, MS-Access97 will cast out queries
> > like:
> > select blah from blub where
> > field1=... and field2=... and field3=... and fieldn or
> > field1=... and ... or
> > field1=...
> >
> > Imagine what this does to your Postgres Server.
> > Here in our environment the postmaster inflates up to
> > 40 Megs of Mem-Usage and drains all CPU even if
> > opening a table just for viewing.
> >
> > SQL7.0 instead seems to optimize these
> > ridiculous queries quite well.
> >
> > If you want the best cross platform utility you
> > might try pgaccess (it runs under TCL/TK) and
> > should run on WIN32 Clients as well.
> >
> > > Did I hear a sideways recommendation of dbKit?
> >
> > Never heard of it. What is it?
> >
> > t++
> >
> > --
> > This mail had been created using Linux. It is therefore free of all
> > Microsoft(tm) OS based virii, conforms with almost any widely recognized
> > open standards and is best read with *any* mailclient using fixed fonts.
> > Spam is processed at the modest price of $500 only at this site.
> >
> > ************
>
> ************

--
wuulong Sheu ( 許武龍 ) - PGP , HTML mail is welcome
蒙恬科技 - PEN POWER TECHNOLOGY LTD.(www.penpower.com.tw)
wuulong(at)penpower(dot)com(dot)tw (O)035722691-362 (M)0923135231 (icq)11934112