I have recently moved to a Linux environment from Windows. I know that you can connect to PostgreSQL via JDBC with Java and ODBC with Microsoft programs, but what is the best way to connect to PostgreSQL from an application written to run on Linux? I will most likely be writing the GUI with GTK and Gnome. Any suggestions?
Thanks,
Landon