ShpLoaderGetSQLCopyStatement()

int ShpLoaderGetSQLCopyStatement	(	SHPLOADERSTATE *	state,
		char **	strheader
	)

if we need to transform we copy into temp table instead of main table first

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

{
        //char *copystr;
        stringbuffer_t *sb;
        char *ret;
        sb = stringbuffer_create();
        stringbuffer_clear(sb);
 
 
        /* Allocate the string for the COPY statement */
        if (state->config->dump_format)
        {
                stringbuffer_aprintf(sb, "COPY ");
 
                if (state->to_srid != state->from_srid){
                        stringbuffer_aprintf(sb, " \"pgis_tmp_%s\" (%s) FROM stdin;\n", state->config->table, state->col_names);
                }
                else {
                        if (state->config->schema)
                        {
                                stringbuffer_aprintf(sb, " \"%s\".", state->config->schema);
                        }
 
                        stringbuffer_aprintf(sb, "\"%s\" (%s) FROM stdin;\n", state->config->table, state->col_names);
                }
 
                /* 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);
 
                *strheader = ret;
                return SHPLOADEROK;
        }
        else
        {
                /* Flag an error as something has gone horribly wrong */
                snprintf(state->message, SHPLOADERMSGLEN, _("Internal error: attempt to generate a COPY statement for data that hasn't been requested in COPY format"));
 
                return SHPLOADERERR;
        }
}

References _, shp_loader_state::col_names, shp_loader_state::config, shp_loader_config::dump_format, shp_loader_state::from_srid, malloc(), shp_loader_state::message, shp_loader_config::schema, SHPLOADERERR, SHPLOADERMSGLEN, SHPLOADEROK, stringbuffer_aprintf(), stringbuffer_clear(), stringbuffer_create(), stringbuffer_destroy(), stringbuffer_getstring(), shp_loader_config::table, and shp_loader_state::to_srid.

Referenced by main(), and pgui_action_import().

Here is the call graph for this function:

Here is the caller graph for this function: