organize the PostgreSQL database connection parameters using libpq?

Question

I'm trying to figure out the correct way to pass database connection parameters to this libpq connection control function.

PQconnectdbParams

PGconn *PQconnectdbParams(const char * const *keywords,
    const char * const *values, int expand_dbname);

klin · Accepted Answer · 2018-04-02 22:02:09Z

2

From the documentation:

This function opens a new database connection using the parameters taken from two NULL-terminated arrays. The first, keywords, is defined as an array of strings, each one being a key word. The second, values, gives the value for each key word.

I have never used this function in practice (as PQconnectdb() seems simpler), but this example should work I think:

char *keywords[] = {"hostaddr", "port", "dbname", 0};
char *values[] = {"127.0.0.1", "5432", "testdb", 0};

conn = PQconnectdbParams((const char **)keywords, (const char **)values, 0);

edited Apr 2, 2018 at 22:02

answered Apr 2, 2018 at 21:42

klin

123k15 gold badges241 silver badges263 bronze badges

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

Collectives™ on Stack Overflow

organize the PostgreSQL database connection parameters using libpq?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related