Export Shapes

Author: O.Conrad (c) 2013
Menu: Database | PostgreSQL | Shapes

Description

Exports shapes to a PostGIS database.

Parameters

	Name	Type	Identifier	Description	Constraints
Input	Shapes	shapes, input	`SHAPES`	-	-
Options	Host	text	`PG_HOST`	-	Default: 127.0.0.1
	Port	integer number	`PG_PORT`	-	Minimum: 0 Default: 5432
	Database	text	`PG_DB`	-	-
	User	text	`PG_USER`	-	-
	Password	text	`PG_PWD`	-	-
	Primary Key	table fields	`SHAPES_PK`	-	-
	Not Null	table fields	`SHAPES_NN`	-	-
	Unique	table fields	`SHAPES_UQ`	-	-
	Table Name	text	`NAME`	if empty shapes layers's name is used as table name	-
	If table exists...	choice	`EXISTS`	-	Available Choices: [0] abort export [1] replace existing table [2] append records, if table structure allows Default: 0
	Authority Code	integer number	`CRS_CODE`	-	Minimum: -1 Default: -1
	Authority	text	`CRS_AUTHORITY`	-	Default: EPSG

Command Line


Usage: saga_cmd db_pgsql 21 [-PG_HOST ] [-PG_PORT ] [-PG_DB ] [-PG_USER ] [-PG_PWD ] [-SHAPES ] [-SHAPES_PK ] [-SHAPES_NN ] [-SHAPES_UQ ] [-NAME ] [-EXISTS ] [-CRS_CODE ] [-CRS_AUTHORITY ]
  -PG_HOST:      	Host
	text
	Default: 127.0.0.1
  -PG_PORT:      	Port
	integer number
	Minimum: 0
	Default: 5432
  -PG_DB:        	Database
	text
  -PG_USER:      	User
	text
  -PG_PWD:       	Password
	text
  -SHAPES:       	Shapes
	shapes, input
  -SHAPES_PK:    	Primary Key
	table fields
  -SHAPES_NN:    	Not Null
	table fields
  -SHAPES_UQ:    	Unique
	table fields
  -NAME:         	Table Name
	text
  -EXISTS:       	If table exists...
	choice
	Available Choices:
	[0] abort export
	[1] replace existing table
	[2] append records, if table structure allows
	Default: 0
  -CRS_CODE:     	Authority Code
	integer number
	Minimum: -1
	Default: -1
  -CRS_AUTHORITY:	Authority
	text
	Default: EPSG