Tool Export Shapes to PostGIS

Exports shapes to a PostGIS database.

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

Parameters

	Name	Type	Identifier	Description	Constraints
Input	Shapes	Shapes, input	`SHAPES`	-	-
Options	Host	Text, CMD	`PG_HOST`	Password	-
	Port	Integer, CMD	`PG_PORT`	-	Minimum: 0 Default: 5432
	Database	Text, CMD	`PG_NAME`	Database Name	-
	User	Text, CMD	`PG_USER`	User Name	-
	Password	Text, CMD	`PG_PWD`	Password	-
	Available Connections	Choice, GUI	`CONNECTION`	-	Available Choices: Default: 0
	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
	EPSG Code	Integer	`CRS_EPSG`	-	Minimum: -1 Default: -1

Command-line

Usage: saga_cmd db_pgsql 21 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-SHAPES <str>] [-SHAPES_PK <str>] [-SHAPES_NN <str>] [-SHAPES_UQ <str>] [-NAME <str>] [-EXISTS <str>] [-CRS_EPSG <num>]
  -PG_HOST:<str>  	Host
	Text, CMD
  -PG_PORT:<num>  	Port
	Integer, CMD
	Minimum: 0
	Default: 5432
  -PG_NAME:<str>  	Database
	Text, CMD
  -PG_USER:<str>  	User
	Text, CMD
  -PG_PWD:<str>   	Password
	Text, CMD
  -SHAPES:<str>   	Shapes
	Shapes, input
  -SHAPES_PK:<str>	Primary Key
	Table fields
  -SHAPES_NN:<str>	Not Null
	Table fields
  -SHAPES_UQ:<str>	Unique
	Table fields
  -NAME:<str>     	Table Name
	Text
  -EXISTS:<str>   	If table exists...
	Choice
	Available Choices:
	[0] abort export
	[1] replace existing table
	[2] append records, if table structure allows
	Default: 0
  -CRS_EPSG:<num> 	EPSG Code
	Integer
	Minimum: -1
	Default: -1