SAGA 9.4.2 | Tool Library Documentation

Connect to PostgreSQL


Description

Connect to PostgreSQL data source.


Parameters

 NameTypeIdentifierDescriptionConstraints
OptionsHosttextPG_HOST-Default: localhost
Portinteger numberPG_PORT-Minimum: 0 Default: 5432
DatabasetextPG_DB--
Databasechoice, GUIPG_LIST-Available Choices: Default: 0
UsertextPG_USER-Default: postgres
PasswordtextPG_PWD-Default: postgres

Command Line


Usage: saga_cmd db_pgsql 1 [-PG_HOST ] [-PG_PORT ] [-PG_DB ] [-PG_USER ] [-PG_PWD ]
  -PG_HOST:	Host
	text
	Default: localhost
  -PG_PORT:	Port
	integer number
	Minimum: 0
	Default: 5432
  -PG_DB:  	Database
	text
  -PG_USER:	User
	text
	Default: postgres
  -PG_PWD: 	Password
	text
	Default: postgres