Обсуждение: windoze accesse to pg backend

I am wondering what 'common' solutions are used to access postgress data
on unix back ends.

I'd be glad to tabulate results for the list, but don't even know all the
options.

I am thinking of


     MS-Access     Paradox     Excel     Brio      Other tools

ODBC

other


Note, that I don't know if there is a native lib for accessing postgress
from windows -- I'm thinking of something like the sybase netlibs.

If anyone else wants to add to the above, please feel free.

If I get much of a response, I'll tabulate and repost.   Thx.

--
David Bear
College of Public Programs/ASU
480-965-8257
...the way is like water, going where nobody wants it to go

On Tuesday, November 27, 2001, at 03:25  AM, David Bear wrote:

>
> I am wondering what 'common' solutions are used to access postgress data
> on unix back ends.


There is an ODBC driver on the postgres website which works quite well
for me with Access for people in the office on Windows workstations
querying the database.

==============================
David Stanaway
Personal: david@stanaway.net
Work: david@netventures.com.au

At 09:25 AM 11/26/2001 , David Bear wrote:
>I am wondering what 'common' solutions are used to access postgress data
>on unix back ends.
>
>I'd be glad to tabulate results for the list, but don't even know all the
>options.

The native tool "psql" is commonly used.  There is a graphical front end
for windows called pgAdmin that is quite useful.

Beyond that, I'd guess ODBC and JDBC are the most common methods.

Also, the protocol between the client and the server is documented in
chapter 4 of the Developer's Guide in case you want to write your own
custom client.  I'd discourage that and stick to ODBC or JDBC for
portability of your application.


         -crl
--
Chad R. Larson (CRL22)    chad@eldocomp.com
   Eldorado Computing, Inc.   602-604-3100
      5353 North 16th Street, Suite 400
        Phoenix, Arizona  85016-3228