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´t 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 ( ³\ªZÀs ) - PGP , HTML mail is welcome »X«ï¬ì§Þ - PEN POWER TECHNOLOGY LTD.(www.penpower.com.tw) [EMAIL PROTECTED] (O)035722691-362 (M)0923135231 (icq)11934112 ************