Re: how do I get arbitrary sql results as strings in C - Mailing list pgsql-general

If there's no simple way to do this, I think I found an example of what I
need in function printQuery in psql/print.c

Alex.

On Fri, 23 Feb 2001, adb wrote:

>
> Is there an easy way in libpq to get the results from
> any query as strings.
>
> Imagine a cgi where you input any query and then it prints
> out the rows returned
>
> Something like this example of mysql code:
>
> // fetch each row using mysql_fetch_row
>   MYSQL_ROW row;
>   unsigned int num_fields;
>
>   if( sql_result ) {
>     num_fields = mysql_num_fields( sql_result );
>
>     while( ( row = mysql_fetch_row( sql_result ) ) ) {
>
>       outputBuf_.print( L"<r>" );
>       for( unsigned int i = 0; i < num_fields ; i++ ) {
>         char * rowVal = row[i];
>         if( !rowVal ) {
>           rowVal = "";
>         }
>
>         outputBuf_.print( L"<c>%a</c>", rowVal );
>       }
>       outputBuf_.print( L"</r>\n" );
>     }
>   }
>
> Thanks,
>
> Alex.
>