SAGA-GIS Tool Library Documentation (v7.6.1)

Tool Export Raster to PostGIS

Exports grids to a PostGIS database.

Parameters

 NameTypeIdentifierDescriptionConstraints
InputBandsGrid list (input)GRIDS--
OptionsHostTextPG_HOSTPassword-
PortIntegerPG_PORT-Minimum: 0
Default: 5432
DatabaseTextPG_NAMEDatabase Name-
UserTextPG_USERUser Name-
PasswordTextPG_PWDPassword-
Available ConnectionsChoiceCONNECTION-Available Choices:
Default: 0
Grid SystemGrid systemGRID_SYSTEM--
Add to TableChoiceTABLE-Available Choices:
Default: 0
Table NameTextNAME--
Band Name FieldBooleanGRID_NAME-Default: 1
EPSG CodeIntegerCRS_EPSG-Minimum: -1
Default: -1

Command-line

Usage: saga_cmd db_pgsql 31 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-GRIDS <str>] [-TABLE <str>] [-NAME <str>] [-GRID_NAME <str>] [-CRS_EPSG <num>]
  -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
  -GRIDS:<str>    	Bands
	Grid list (input)
  -TABLE:<str>    	Add to Table
	Choice
	Available Choices:
	Default: 0
  -NAME:<str>     	Table Name
	Text
  -GRID_NAME:<str>	Band Name Field
	Boolean
	Default: 1
  -CRS_EPSG:<num> 	EPSG Code
	Integer
	Minimum: -1
	Default: -1