The below mentioned pg_database does not appear in $1.
In the postgresql.log I get "select datname from $1".
Do you have a suggestion of how to solve this?
I get double declarations when using both
char *paramValues[1]
char *paramValues[1]
//char *value1 = "pg_database";
//char **paramValues = &value1; /* closer match to the documentation's
syntax */
char *paramValues[1] = {"pg_database"}; /* same as above, different syntax
*/
//
//char *paramValues[1]; /* this looks to be missing */
//paramValues[0]={"pg_database"}; /* what you had */
res = PQexecParams(conn,
"select datname from $1",
1, /* there is only 1 entry in paramValues array */
NULL,
paramValues, /* address of parameter value array */
NULL, /* don't need param lengths since text */
NULL, /* defaul to all text params */
1); /* return all values as binary */
Thanks.
/Poul
2016-11-22 15:50 GMT+01:00 John McKown <john.archie.mck...@gmail.com>:
> On Tue, Nov 22, 2016 at 8:22 AM, Poul Kristensen <bcc5...@gmail.com>
> wrote:
>
>> I think I understand.
>> When I use this in my code I get
>> "undefined reference to `PQexecParms'
>>
>
> The correct name is PQexecParams (note the last "a"). Sorry I missed that
> when first looking. Also, just to be sure, did you include the argument
> "-lpq" on the compile command to point to the PostgreSQL library for
> linking?
>
>
>
>> when compiling.
>>
>> references in main is
>>
>> const char *conninfo; /* connection string to the database */
>> PGconn *conn; /* connection to the database */
>> PGresult *res; /* result of sql query */
>> int nFields; /* print out the attribute names */
>> int i; / * print the columns */
>> j;
>>
>> Is the a reserved reference to use with
>>
>> Reserved res = PQexecParms(conn.... )
>>
>> Then I assume that I have to use another reference than res.
>>
>> Thanks.
>>
>> /Poul
>>
>>
> --
> Heisenberg may have been here.
>
> Unicode: http://xkcd.com/1726/
>
> Maranatha! <><
> John McKown
>
--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
