Skip site navigation (1) Skip section navigation (2)

RE: ODBC driver

From: Nicolas Huillard <nhuillard(at)ghs(dot)fr>
To: "'Mihai Gheorghiu'" <tanhq(at)bigplanet(dot)com>, "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: ODBC driver
Date: 2000-06-02 10:12:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
The best way to see how it works is to look at the query log in the postgres back-end. My bet is that Access will send select/where-clauses and so on to the back-end, for each table, and then do it's join locally, on the subset of the data. Maybe it can work even smarter...

Nicolas Huillard

-----Message d'origine-----
De:	Mihai Gheorghiu [SMTP:tanhq(at)bigplanet(dot)com]
Date:	jeudi 1 juin 2000 23:49
À:	pgsql-interfaces(at)postgresql(dot)org
Objet:	ODBC driver

A previous message mentioned that MSAccess performs a join locally when
accessing a postgres database via the ODBC drivers (link files).
Does that mean that it sends the entire tables from the postgres server to
the Win computer and the query is actually performed by MSAccess?


Mihai Gheorghiu

pgsql-interfaces by date

Next:From: Patrick WelcheDate: 2000-06-02 10:27:02
Subject: Re: PostgreSQL JDBC error: Missing or erroneous pg_hba.conf file
Previous:From: Wim CeulemansDate: 2000-06-02 09:00:01
Subject: Re: TCP/IP DB connection for a Macintosh?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group