getMaxFieldSize()

static int getMaxFieldSize ( PGconn *  conn, char *  schema, char *  table, char *  fname  )

static

Definition at line 555 of file pgsql2shp-core.c.

{
        int size;
        stringbuffer_t query;
        PGresult *res;
 
        /*( this is ugly: don't forget counting the length  */
        /* when changing the fixed query strings ) */
 
        stringbuffer_init(&query);
        if ( schema )
        {
                stringbuffer_aprintf(
                        &query,
                        "select max(octet_length(\"%s\"::text)) from \"%s\".\"%s\"",
                        fname, schema, table);
        }
        else
        {
                stringbuffer_aprintf(
                        &query,
                        "select max(octet_length(\"%s\"::text)) from \"%s\"",
                        fname, table);
        }
 
        LWDEBUGF(4, "maxFieldLenQuery: %s\n", stringbuffer_getstring(&query));
 
        res = PQexec(conn, stringbuffer_getstring(&query));
        stringbuffer_release(&query);
        if ( ! res || PQresultStatus(res) != PGRES_TUPLES_OK )
        {
                printf( _("Querying for maximum field length: %s"),
                        PQerrorMessage(conn));
                return -1;
        }
 
        if (PQntuples(res) <= 0 )
        {
                PQclear(res);
                return -1;
        }
        size = atoi(PQgetvalue(res, 0, 0));
        PQclear(res);
        return size;
}

References _, conn, LWDEBUGF, stringbuffer_aprintf(), stringbuffer_getstring(), stringbuffer_init(), and stringbuffer_release().

Referenced by ShpDumperOpenTable().

Here is the call graph for this function:

Here is the caller graph for this function: