Tool Export Table

Exports a table to a PostgreSQL database.

Author: O.Conrad (c) 2013
Menu: Database|PostgreSQL|Tables

Parameters

	Name	Type	Identifier	Description	Constraints
Input	Table	table, input	`TABLE`	-	-
Options	Host	text, CMD	`PG_HOST`	-	Default: 127.0.0.1
	Port	integer number, CMD	`PG_PORT`	-	Minimum: 0 Default: 5432
	Database	text, CMD	`PG_NAME`	-	-
	User	text, CMD	`PG_USER`	-	-
	Password	text, CMD	`PG_PWD`	-	-
	Connections	choice, GUI	`CONNECTION`	-	Available Choices: Default: 0
	Primary Key	table fields	`TABLE_PK`	-	-
	Not Null	table fields	`TABLE_NN`	-	-
	Unique	table fields	`TABLE_UQ`	-	-
	Table Name	text	`NAME`	-	-
	If table exists...	choice	`EXISTS`	-	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
	Default: 127.0.0.1
  -PG_PORT:<num> 	Port
	integer number, 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