PostGIS  3.1.6dev-r@@SVN_REVISION@@

◆ 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 1490 of file shp2pgsql-core.c.

1491 {
1492  //char *copystr;
1493  stringbuffer_t *sb;
1494  char *ret;
1495  sb = stringbuffer_create();
1496  stringbuffer_clear(sb);
1497 
1498 
1499  /* Allocate the string for the COPY statement */
1500  if (state->config->dump_format)
1501  {
1502  stringbuffer_aprintf(sb, "COPY ");
1503 
1504  if (state->to_srid != state->from_srid){
1506  stringbuffer_aprintf(sb, " \"pgis_tmp_%s\" (%s) FROM stdin;\n", state->config->table, state->col_names);
1507  }
1508  else {
1509  if (state->config->schema)
1510  {
1511  stringbuffer_aprintf(sb, " \"%s\".", state->config->schema);
1512  }
1513 
1514  stringbuffer_aprintf(sb, "\"%s\" (%s) FROM stdin;\n", state->config->table, state->col_names);
1515  }
1516 
1517  /* Copy the string buffer into a new string, destroying the string buffer */
1518  ret = (char *)malloc(strlen((char *)stringbuffer_getstring(sb)) + 1);
1519  strcpy(ret, (char *)stringbuffer_getstring(sb));
1521 
1522  *strheader = ret;
1523  return SHPLOADEROK;
1524  }
1525  else
1526  {
1527  /* Flag an error as something has gone horribly wrong */
1528  snprintf(state->message, SHPLOADERMSGLEN, _("Internal error: attempt to generate a COPY statement for data that hasn't been requested in COPY format"));
1529 
1530  return SHPLOADERERR;
1531  }
1532 }
void * malloc(YYSIZE_T)
#define SHPLOADERMSGLEN
#define SHPLOADERERR
#define SHPLOADEROK
#define _(String)
Definition: shpcommon.h:24
void stringbuffer_clear(stringbuffer_t *s)
Reset the stringbuffer_t.
Definition: stringbuffer.c:88
int stringbuffer_aprintf(stringbuffer_t *s, const char *fmt,...)
Appends a formatted string to the current string buffer, using the format and argument list provided.
Definition: stringbuffer.c:228
stringbuffer_t * stringbuffer_create(void)
Allocate a new stringbuffer_t.
Definition: stringbuffer.c:33
void stringbuffer_destroy(stringbuffer_t *s)
Free the stringbuffer_t and all memory managed within it.
Definition: stringbuffer.c:76
const char * stringbuffer_getstring(stringbuffer_t *s)
Returns a reference to the internal string being managed by the stringbuffer.
Definition: stringbuffer.c:113
char message[SHPLOADERMSGLEN]
SHPLOADERCONFIG * config

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 pgui_action_import().

Here is the call graph for this function:
Here is the caller graph for this function: