SAGA-GIS Tool Library Documentation (v6.2.0)

Tool Import Shapes with Joined Data from PostGIS (GUI)

Imports shapes with joined data from a PostGIS database.

Parameters

 NameTypeIdentifierDescriptionConstraints
OutputShapesShapes (output)SHAPES--
OptionsHostTextPG_HOSTPassword-
PortIntegerPG_PORT-Minimum: 0
Default: 5432
DatabaseTextPG_NAMEDatabase Name-
UserTextPG_USERUser Name-
PasswordTextPG_PWDPassword-
Available ConnectionsChoiceCONNECTION-Available Choices:
[0]
Default: 0
Geometry TableChoiceGEO_TABLE-Available Choices:
[0]
Default: 0
KeyChoiceGEO_KEY-Available Choices:
[0]
Default: 0
Join TableChoiceJOIN_TABLE-Available Choices:
[0]
Default: 0
KeyChoiceJOIN_KEY-Available Choices:
[0]
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
  -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