Export Shapes to PostGIS
- 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 | Connection | choice | CONNECTION | - | Available Choices:
Default: 0 |
| 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 |
| EPSG Code | integer number | CRS_EPSG | - | Minimum: -1
Default: -1 |
| Geographic Coordinate Systems | choice | CRS_EPSG_GEOGCS | - | Available Choices:
[0] |
| Projected Coordinate Systems | choice | CRS_EPSG_PROJCS | - | Available Choices:
[0] |
Command Line
Usage: saga_cmd db_pgsql 21 [-CONNECTION ] [-SHAPES ] [-SHAPES_PK ] [-SHAPES_NN ] [-SHAPES_UQ ] [-NAME ] [-EXISTS ] [-CRS_EPSG ] [-CRS_EPSG_GEOGCS ] [-CRS_EPSG_PROJCS ]
-CONNECTION: Connection
choice
Available Choices:
Default: 0
-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_EPSG: EPSG Code
integer number
Minimum: -1
Default: -1
-CRS_EPSG_GEOGCS: Geographic Coordinate Systems
choice
Available Choices:
[0]