Export Shapes
- Author: O.Conrad (c) 2013
- Menu: Database | PostgreSQL | Shapes
Description
Exports shapes to a PostGIS database.
Parameters
Name | Type | Identifier | Description | Constraints | |
---|---|---|---|---|---|
Input | Shapes | shapes, input | SHAPES | - | - |
Options | Host | text | PG_HOST | - | Default: 127.0.0.1 |
Port | integer number | PG_PORT | - | Minimum: 0 Default: 5432 | |
Database | text | PG_DB | - | - | |
User | text | PG_USER | - | - | |
Password | text | PG_PWD | - | - | |
Primary Key | table fields | SHAPES_PK | - | - | |
Not Null | table fields | SHAPES_NN | - | - | |
Unique | table fields | SHAPES_UQ | - | - | |
Table Name | text | NAME | if empty shapes layers's name is used as table name | - | |
If table exists... | choice | EXISTS | - | Available Choices: [0] abort export [1] replace existing table [2] append records, if table structure allows Default: 0 | |
Authority Code | integer number | CRS_CODE | - | Minimum: -1 Default: -1 | |
Authority | text | CRS_AUTHORITY | - | Default: EPSG |
Command Line
Usage: saga_cmd db_pgsql 21 [-PG_HOST] [-PG_PORT ] [-PG_DB ] [-PG_USER ] [-PG_PWD ] [-SHAPES ] [-SHAPES_PK ] [-SHAPES_NN ] [-SHAPES_UQ ] [-NAME ] [-EXISTS ] [-CRS_CODE ] [-CRS_AUTHORITY ] -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 -SHAPES: Shapes shapes, input -SHAPES_PK: Primary Key table fields -SHAPES_NN: Not Null table fields -SHAPES_UQ: Unique table fields -NAME: Table Name text -EXISTS: If table exists... choice Available Choices: [0] abort export [1] replace existing table [2] append records, if table structure allows Default: 0 -CRS_CODE: Authority Code integer number Minimum: -1 Default: -1 -CRS_AUTHORITY: Authority text Default: EPSG