ShpLoaderGetSQLFooter()

int ShpLoaderGetSQLFooter	(	SHPLOADERSTATE *	state,
		char **	strfooter
	)

We need to copy from the temp table to the real table, transforming to to_srid

Definition at line 1878 of file shp2pgsql-core.c.

{
        stringbuffer_t *sb;
        char *ret;
 
        /* Create the stringbuffer containing the header; we use this API as it's easier
           for handling string resizing during append */
        sb = stringbuffer_create();
        stringbuffer_clear(sb);
 
        if ( state->config->dump_format && state->to_srid != state->from_srid){
                stringbuffer_aprintf(sb, "ALTER TABLE  \"pgis_tmp_%s\" ALTER COLUMN \"%s\" TYPE ", state->config->table, state->geo_col);
                if (state->config->geography){
                        stringbuffer_aprintf(sb, "geography USING (ST_Transform(\"%s\", %d)::geography );\n", state->geo_col, state->to_srid);
                }
                else {
                        stringbuffer_aprintf(sb, "geometry USING (ST_Transform(\"%s\", %d)::geometry );\n", state->geo_col, state->to_srid);
                }
                stringbuffer_aprintf(sb, "INSERT INTO ");
                // /* Schema is optional, include if present. */
                if (state->config->schema)
                {
                        stringbuffer_aprintf(sb, "\"%s\".", state->config->schema);
                }
                stringbuffer_aprintf(sb, "\"%s\" (%s) ", state->config->table, state->col_names);
                stringbuffer_aprintf(sb, "SELECT %s FROM \"pgis_tmp_%s\";\n", state->col_names, state->config->table);
        }
 
        /* Create gist index if specified and not in "prepare" mode */
        if (state->config->readshape && state->config->createindex)
        {
                stringbuffer_aprintf(sb, "CREATE INDEX ON ");
                /* Schema is optional, include if present. */
                if (state->config->schema)
                {
                        stringbuffer_aprintf(sb, "\"%s\".",state->config->schema);
                }
                stringbuffer_aprintf(sb, "\"%s\" USING GIST (\"%s\")", state->config->table, state->geo_col);
                /* Tablespace is also optional. */
                if (state->config->idxtablespace != NULL)
                {
                        stringbuffer_aprintf(sb, " TABLESPACE \"%s\"", state->config->idxtablespace);
                }
                stringbuffer_aprintf(sb, ";\n");
        }
 
        /* End the transaction if there is one. */
        if (state->config->usetransaction)
        {
                stringbuffer_aprintf(sb, "COMMIT;\n");
        }
 
        /* Always ANALYZE the resulting table, for better stats */
        stringbuffer_aprintf(sb, "ANALYZE ");
        if (state->config->schema)
        {
                stringbuffer_aprintf(sb, "\"%s\".", state->config->schema);
        }
        stringbuffer_aprintf(sb, "\"%s\";\n", state->config->table);
 
        /* Copy the string buffer into a new string, destroying the string buffer */
        ret = (char *)malloc(strlen((char *)stringbuffer_getstring(sb)) + 1);
        strcpy(ret, (char *)stringbuffer_getstring(sb));
        stringbuffer_destroy(sb);
 
        *strfooter = ret;
 
        return SHPLOADEROK;
}

References shp_loader_state::col_names, shp_loader_state::config, shp_loader_config::createindex, shp_loader_config::dump_format, shp_loader_state::from_srid, shp_loader_state::geo_col, shp_loader_config::geography, shp_loader_config::idxtablespace, malloc(), shp_loader_config::readshape, shp_loader_config::schema, SHPLOADEROK, stringbuffer_aprintf(), stringbuffer_clear(), stringbuffer_create(), stringbuffer_destroy(), stringbuffer_getstring(), shp_loader_config::table, shp_loader_state::to_srid, and shp_loader_config::usetransaction.

Referenced by main(), and pgui_action_import().

Here is the call graph for this function:

Here is the caller graph for this function: