SAGA-GIS Tool Library Documentation (v9.2.0)

Tool Import Shapes with Joined Data from PostGIS (GUI)

Imports shapes with joined data from a PostGIS database.

Parameters

 NameTypeIdentifierDescriptionConstraints
OutputShapesshapes, outputSHAPES--
OptionsHosttext, CMDPG_HOST-Default: 127.0.0.1
Portinteger number, CMDPG_PORT-Minimum: 0
Default: 5432
Databasetext, CMDPG_NAME--
Usertext, CMDPG_USER--
Passwordtext, CMDPG_PWD--
Connectionschoice, GUICONNECTION-Available Choices:
Default: 0
Geometry TablechoiceGEO_TABLE-Available Choices:
Default: 0
KeychoiceGEO_KEY-Available Choices:
Default: 0
Join TablechoiceJOIN_TABLE-Available Choices:
Default: 0
KeychoiceJOIN_KEY-Available Choices:
Default: 0
FieldsparametersFIELDS-0 Parameters:
WheretextWHERE--

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, CMD
	Default: 127.0.0.1
  -PG_PORT:<num>   	Port
	integer number, 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, output
  -GEO_TABLE:<str> 	Geometry Table
	choice
	Available Choices:
	Default: 0
  -GEO_KEY:<str>   	Key
	choice
	Available Choices:
	Default: 0
  -JOIN_TABLE:<str>	Join Table
	choice
	Available Choices:
	Default: 0
  -JOIN_KEY:<str>  	Key
	choice
	Available Choices:
	Default: 0
  -WHERE:<str>     	Where
	text