SAGA 9.6.1 | Tool Library Documentation

Disconnect from PostgreSQL


Description

Disconnect PostgreSQL data source.


Parameters

 NameTypeIdentifierDescriptionConstraints
OptionsHosttextPG_HOST-Default: 127.0.0.1
Portinteger numberPG_PORT-Minimum: 0 Default: 5432
DatabasetextPG_DB--
UsertextPG_USER--
PasswordtextPG_PWD--
TransactionschoiceTRANSACT-Available Choices: [0] rollback [1] commit Default: 1

Command Line


Usage: saga_cmd db_pgsql 2 [-PG_HOST ] [-PG_PORT ] [-PG_DB ] [-PG_USER ] [-PG_PWD ] [-TRANSACT ]
  -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
  -TRANSACT:	Transactions
	choice
	Available Choices:
	[0] rollback
	[1] commit
	Default: 1