SAGA-GIS Tool Library Documentation (v7.7.0)

Tool Export Table

Exports a table to a PostgreSQL database.

Parameters

 NameTypeIdentifierDescriptionConstraints
InputTableTable, inputTABLE--
OptionsHostText, CMDPG_HOSTPassword-
PortInteger, CMDPG_PORT-Minimum: 0
Default: 5432
DatabaseText, CMDPG_NAMEDatabase Name-
UserText, CMDPG_USERUser Name-
PasswordText, CMDPG_PWDPassword-
Available ConnectionsChoice, GUICONNECTION-Available Choices:
Default: 0
Primary KeyTable fieldsTABLE_PK--
Not NullTable fieldsTABLE_NN--
UniqueTable fieldsTABLE_UQ--
Table NameTextNAME--
If table exists...ChoiceEXISTS-Available Choices:
[0] abort export
[1] replace existing table
[2] append records, if table structure allows
Default: 0

Command-line

Usage: saga_cmd db_pgsql 13 [-PG_HOST <str>] [-PG_PORT <num>] [-PG_NAME <str>] [-PG_USER <str>] [-PG_PWD <str>] [-TABLE <str>] [-TABLE_PK <str>] [-TABLE_NN <str>] [-TABLE_UQ <str>] [-NAME <str>] [-EXISTS <str>]
  -PG_HOST:<str> 	Host
	Text, CMD
  -PG_PORT:<num> 	Port
	Integer, CMD
	Minimum: 0
	Default: 5432
  -PG_NAME:<str> 	Database
	Text, CMD
  -PG_USER:<str> 	User
	Text, CMD
  -PG_PWD:<str>  	Password
	Text, CMD
  -TABLE:<str>   	Table
	Table, input
  -TABLE_PK:<str>	Primary Key
	Table fields
  -TABLE_NN:<str>	Not Null
	Table fields
  -TABLE_UQ:<str>	Unique
	Table fields
  -NAME:<str>    	Table Name
	Text
  -EXISTS:<str>  	If table exists...
	Choice
	Available Choices:
	[0] abort export
	[1] replace existing table
	[2] append records, if table structure allows
	Default: 0