Retrieve a list of the databases from postgres server via libpq

Question

I've tried to find a way to ask the postgres server for the current list of databases (and later list and describe the tables) from a C program using the libpq library. Currently I'm doing a (simplified) popen("psql --command '\\l'") but this is not really how I would like to solve the problem ... Is there any way of asking the postgres server for the information I need via a libpq function?

Try this? stackoverflow.com/questions/11650018/…

richyen
– richyen

2020-12-21 08:46:11 +00:00
Commented Dec 21, 2020 at 8:46 — richyen
– richyen, Commented Dec 21, 2020 at 8:46

Laurenz Albe · Accepted Answer · 2020-12-21 09:18:54Z

1

You can run a metadata query like

SELECT ... FROM pg_database;

The columns you select will depend on the information you need.

answered Dec 21, 2020 at 9:18

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrieve a list of the databases from postgres server via libpq

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related