Execute SQL
- Author: O.Conrad (c) 2013
- Menu: Database | PostgreSQL | Tools
Description
Execute SQL commands on a connected PostgreSQL source. Separate different commands with a semicolon (';').
Parameters
| | Name | Type | Identifier | Description | Constraints |
|---|
| Output | Tables | table list, output | TABLES | - | - |
| Options | Connection | choice | CONNECTION | - | Available Choices:
Default: 0 |
| SQL Statement | long text | SQL | - | Default: CREATE TABLE myTable1 (Col1 VARCHAR(255) PRIMARY KEY, Col2 INTEGER);
INSERT INTO myTable1 (Col1, Col2) VALUES('First Value', 1);
DROP TABLE myTable1;
|
| Output | choice | OUTPUT | - | Available Choices:
[0] none
[1] message window
[2] tables
Default: 2 |
| Stop on Error | boolean | STOP | - | Default: 0 |
Command Line
Usage: saga_cmd db_pgsql 6 [-CONNECTION ] [-SQL ] [-TABLES ] [-OUTPUT ] [-STOP ]
-CONNECTION: Connection
choice
Available Choices:
Default: 0
-SQL: SQL Statement
long text
Default: CREATE TABLE myTable1 (Col1 VARCHAR(255) PRIMARY KEY, Col2 INTEGER);
INSERT INTO myTable1 (Col1, Col2) VALUES('First Value', 1);
DROP TABLE myTable1;
-TABLES: Tables
table list, output
-OUTPUT: Output
choice
Available Choices:
[0] none
[1] message window
[2] tables
Default: 2
-STOP: Stop on Error
boolean
Default: 0