create_table()

static int create_table ( const char *  schema, const char *  table, const char *  column, const int  file_column, const char *  file_column_name, const char *  tablespace, const char *  idx_tablespace, STRINGBUFFER *  buffer  )

static

Definition at line 1020 of file raster2pgsql.c.

References _, append_sql_to_buffer(), rtalloc(), rterror(), and rtgdalraster::sql.

Referenced by process_rasters().

  {
        char *sql = NULL;
        uint32_t len = 0;

        assert(table != NULL);
        assert(column != NULL);

        len = strlen("CREATE TABLE  (\"rid\" serial PRIMARY KEY, raster);") + 1;
        if (schema != NULL)
                len += strlen(schema);
        len += strlen(table);
        len += strlen(column);
        if (file_column)
                len += strlen(", text") + strlen(file_column_name);
        if (tablespace != NULL)
                len += strlen(" TABLESPACE ") + strlen(tablespace);
        if (idx_tablespace != NULL)
                len += strlen(" USING INDEX TABLESPACE ") + strlen(idx_tablespace);

        sql = rtalloc(sizeof(char) * len);
        if (sql == NULL) {
                rterror(_("create_table: Could not allocate memory for CREATE TABLE statement"));
                return 0;
        }
        sprintf(sql, "CREATE TABLE %s%s (\"rid\" serial PRIMARY KEY%s%s,%s raster%s%s%s)%s%s;",
                (schema != NULL ? schema : ""),
                table,
                (idx_tablespace != NULL ? " USING INDEX TABLESPACE " : ""),
                (idx_tablespace != NULL ? idx_tablespace : ""),
                column,
                (file_column ? "," : ""),
                (file_column ? file_column_name : ""),
                (file_column ? " text" : ""),
                (tablespace != NULL ? " TABLESPACE " : ""),
                (tablespace != NULL ? tablespace : "")
        );

        append_sql_to_buffer(buffer, sql);

        return 1;
}

Here is the call graph for this function:

Here is the caller graph for this function: