3 ms·
I'm curious, how did you establish the Postgres connection?
by towawy 4y ago
I'm curious, how did you establish the Postgres connection?
- OrvalWintermute 4y agoI used ODBC [1] out of the big list of options [2] which gets a bad rep but worked for my use-cases. The commercial devart plugin [3] looks pretty neat too but I haven't used it yet I've also tried the JDBC connectivity option too [4], but with some different use-cases in mind for Postgres (not about Excel) [1] https://datacornering.com/how-to-connect-to-postgresql-database-with-excel-or-power-bi/ https://datacornering.com/how-to-connect-to-postgresql-datab... [2] https://www.postgresql.org/download/products/2-drivers-and-interfaces/ https://www.postgresql.org/download/products/2-drivers-and-i... [3] https://www.devart.com/excel-addins/postgresql/ https://www.devart.com/excel-addins/postgresql/ [4] https://jdbc.postgresql.org/ https://jdbc.postgresql.org/