PostgreSQL is a database program, comparable with Oracle. PostgreSQL is developed as open source and therefore free of costs. At Alterra-EM a central database (or databases) is maintained on a server which is running permanently. This central server should be used to store valuable data. Contact ... for further information.
Programs for accessing the database
Linking PostgreSQL tables in MS-Access
- Download and install PsqlODBC to your Windows client.
- Edit pg_hba.conf (usually in your PostgreSQL /data directory) to allow for remote access by your client IP address or address range.
- Create an ODBC DSN on your Windows machine using the PostgreSQL driver, pointing to the remote PostgreSQL server.
- Now, just use Access to connect to the local DSN on your Windows machine.
- File | Get External Data | Link Tables ...
- In the Files of type-drop-down, scroll all the way down to ODBC Databases
- Select your new ODBC database
Local installation in Windows
SQL functions have been developed at Alterra. These functions can be installed locally. For an up to date list with examples and tutorial see PostgreSQL SQL extensions