Is it possible to use libpq with the IDF?

[Talesduque]

I need to use a postgres lib to communicate my ESP32 to a postgres database. Anyone knows if it is possible to use this lib on ESP-IDF projects? If not, is there any alternative to communicating to a database with ESP32?

[Victoria Nope]

Proper design would be based on application tier on your server side (which would communicate with data tier). That being followed would mean for you having a server application with which you would communicate e.g. over some known protocol such as TCP, HTTP, etc. (which are having support on your ESP32 client side already implemented) and only that server application would talk with the PostgreSQL data tier.