Re: Pgsql on Windows

On Mon, 13 Oct 2003, Matthew T. O'Connor wrote:

> On Mon, 2003-10-13 at 17:37, Gene Vital wrote:
> > Matthew T. O'Connor wrote:
> > > I don't see how ODBC fits in to this at all.  There is no need for ODBC
> > > if postgresql is running via cygwin, running on a remote linux box, or
> > > even native on windows.
> >
> > I am new to PostgreSQL
> > what other options are available to connect then ?
>
> When you have postgresql support compiled into PHP, then PHP connects
> directly using native PostgreSQL calls (libpq), no ODBC layer to deal
> with.

Note that ODBC may still be preferred if you're trying to write a very
generic app like a bulletin board or something.  But the native layer
generally reveals a little more of the database API to the code, which is
sometimes quite nice too.

It's all a trade off, I mostly use the native pgsql API and am very happy
with it.