Tool Import Shapes with Joined Data from PostGIS (GUI)

Imports shapes with joined data from a PostGIS database.

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

Parameters

	Name	Type	Identifier	Description	Constraints
Output	Shapes	Shapes (output)	`SHAPES`	-	-
Options	Host	Text	`PG_HOST`	Password	-
	Port	Integer	`PG_PORT`	-	Minimum: 0 Default: 5432
	Database	Text	`PG_NAME`	Database Name	-
	User	Text	`PG_USER`	User Name	-
	Password	Text	`PG_PWD`	Password	-
	Available Connections	Choice	`CONNECTION`	-	Available Choices: [0] Default: 0
	Geometry Table	Choice	`GEO_TABLE`	-	Available Choices: [0] Default: 0
	Key	Choice	`GEO_KEY`	-	Available Choices: [0] Default: 0
	Join Table	Choice	`JOIN_TABLE`	-	Available Choices: [0] Default: 0
	Key	Choice	`JOIN_KEY`	-	Available Choices: [0] Default: 0
	Fields	Parameters	`FIELDS`	-	0 Parameters:
	Where	Text	`WHERE`	-	-

Command-line

Usage: saga_cmd db_pgsql 23 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-SHAPES <str>] [-GEO_TABLE <str>] [-GEO_KEY <str>] [-JOIN_TABLE <str>] [-JOIN_KEY <str>] [-WHERE <str>]
  -PG_HOST:<str>   	Host
	Text
  -PG_PORT:<num>   	Port
	Integer
	Minimum: 0
	Default: 5432
  -PG_NAME:<str>   	Database
	Text
  -PG_USER:<str>   	User
	Text
  -PG_PWD:<str>    	Password
	Text
  -SHAPES:<str>    	Shapes
	Shapes (output)
  -GEO_TABLE:<str> 	Geometry Table
	Choice
	Available Choices:
	[0] <not set>
	Default: 0
  -GEO_KEY:<str>   	Key
	Choice
	Available Choices:
	[0] <not set>
	Default: 0
  -JOIN_TABLE:<str>	Join Table
	Choice
	Available Choices:
	[0] <not set>
	Default: 0
  -JOIN_KEY:<str>  	Key
	Choice
	Available Choices:
	[0] <not set>
	Default: 0
  -WHERE:<str>     	Where
	Text