Chapter 19.  Using PostgreSQL and Microsoft Software over the Network

It's not always the software of just one company that reigns over an IT environment. In many office environments, Unix servers have to be connected to office applications. Some powerful tools, such as Samba, are already available and are widespread in the Open Source community to connect a Unix machine to a Windows network. In most cases, databases are connected with a Windows network by using ODBC or some sort of proprietary software offered by many database vendors, such as Oracle. Another possibility is to use Open Source software, such as Perl's DBI interface.

As a rule of thumb we can say that the more Microsoft is involved the more often ODBC is used for database interaction. ...

Get PostgreSQL Developer's Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.