Import Shapes with Joined Data (GUI)

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

Description

Imports shapes with joined data from a PostGIS database.

Parameters

	Name	Type	Identifier	Description	Constraints
Output	Shapes	shapes, output	`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`	-	-
	Geometry Table	choice	`GEO_TABLE`	-	Available Choices: Default: 0
	Key	choice	`GEO_KEY`	-	Available Choices: Default: 0
	Join Table	choice	`JOIN_TABLE`	-	Available Choices: Default: 0
	Key	choice	`JOIN_KEY`	-	Available Choices: Default: 0
	Where	text	`WHERE`	-	-

Command Line


Usage: saga_cmd db_pgsql 23 [-PG_HOST ] [-PG_PORT ] [-PG_DB ] [-PG_USER ] [-PG_PWD ] [-SHAPES ] [-GEO_TABLE ] [-GEO_KEY ] [-JOIN_TABLE ] [-JOIN_KEY ] [-WHERE ]
  -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, output
  -GEO_TABLE:    Geometry Table
	choice
	Available Choices:
	Default: 0
  -GEO_KEY:      Key
	choice
	Available Choices:
	Default: 0
  -JOIN_TABLE:   Join Table
	choice
	Available Choices:
	Default: 0
  -JOIN_KEY:     Key
	choice
	Available Choices:
	Default: 0
  -WHERE:        Where
	text