CLI tool for GC2
$ npm install -g gc2
$ gc2 COMMAND
running command...
$ gc2 (--version|-v)
gc2/2024.10.2 linux-x64 node-v20.18.0
$ gc2 --help [COMMAND]
USAGE
$ gc2 COMMAND
...
$ npm install -g gc2
$ centia COMMAND
running command...
$ centia (--version|-v)
gc2/2024.6.0 linux-x64 node-v18.19.1
$ centia --help [COMMAND]
USAGE
$ centia COMMAND
...
gc2 admin
gc2 client add [NAME]
gc2 client drop [ID]
gc2 client get [ID]
gc2 client update [ID]
gc2 column add [SCHEMA] [TABLE] [COLUMN] [TYPE]
gc2 column default [SCHEMA] [TABLE] [COLUMN] [DEFAULT]
gc2 column drop [SCHEMA] [TABLE] [COLUMN]
gc2 column get [SCHEMA] [TABLE] [COLUMN]
gc2 column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE]
gc2 column rename [SCHEMA] [TABLE] [COLUMN] [NAME]
gc2 column type [SCHEMA] [TABLE] [COLUMN] [TYPE]
gc2 connect
gc2 constraint add [SCHEMA] [TABLE] [COLUMNS] [TYPE] [NAME]
gc2 constraint drop [SCHEMA] [TABLE] [NAME]
gc2 constraint get
gc2 foreign drop SCHEMAS [INCLUDE]
gc2 foreign import SERVER FROM TO [INCLUDE]
gc2 foreign materialize FROM [TO] [INCLUDE]
gc2 grid
gc2 help [COMMANDS]
gc2 import SCHEMA PATH
gc2 index add [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME]
gc2 index drop [SCHEMA] [TABLE] [NAME]
gc2 index get
gc2 login
gc2 privilege get [SCHEMA] [TABLE]
gc2 privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGES]
gc2 rule add
gc2 rule drop [ID]
gc2 rule get [ID]
gc2 rule update [ID]
gc2 scheduler start JOB [INCLUDE]
gc2 scheduler status
gc2 schema add [SCHEMA]
gc2 schema drop [SCHEMA]
gc2 schema get [SCHEMA]
gc2 schema rename [SCHEMA] [NAME]
gc2 seed list
gc2 seed log
gc2 seed start
gc2 seed stop
gc2 sql
gc2 stat
gc2 symbol PATH
gc2 table add [SCHEMA] [TABLE]
gc2 table drop [SCHEMA] [TABLE]
gc2 table get [SCHEMA] [TABLE]
gc2 table move [SCHEMA] [TABLE] [DESTINATION]
gc2 table rename [SCHEMA] [TABLE] [NAME]
gc2 update [CHANNEL]
gc2 user add [NAME]
gc2 user drop [NAME]
gc2 user get
gc2 user update [NAME]
gc2 view backup SCHEMAS
gc2 view get SCHEMA
gc2 view refresh SCHEMAS [INCLUDE]
gc2 view restore FROM [TO] [INCLUDE]
Run administration task on the GC2 installation.
USAGE
$ gc2 admin -t
mapfiles|mapcachefile|qgisfiles|schema|migrations|diskcleanup|cachestats|cachecleanup|insertmeta
FLAGS
-t, --task=<option> (required) The task to run
<options:
mapfiles|mapcachefile|qgisfiles|schema|migrations|diskcleanup|cachestats|cachecleanup|insertmeta>
DESCRIPTION
Run administration task on the GC2 installation.
See code: src/commands/admin.ts
Create new client
USAGE
$ gc2 client add [NAME] [-n <value>] [-d <value>] [-r <value>] [-p <value>] [-h]
ARGUMENTS
NAME Name of new client
FLAGS
-d, --description=<value> Description
-h, --help Show CLI help.
-n, --name=<value> Name
-p, --homepage=<value> Homepage
-r, --redirect_uri=<value> Redirect uri
DESCRIPTION
Create new client
See code: src/commands/client/add.ts
Drop a client.
USAGE
$ gc2 client drop [ID] [-h]
ARGUMENTS
ID Id of client
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop a client.
See code: src/commands/client/drop.ts
Get client(s).
USAGE
$ gc2 client get [ID] [-h]
ARGUMENTS
ID Client id
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get client(s).
See code: src/commands/client/get.ts
Update a client.
USAGE
$ gc2 client update [ID] [-d <value>] [-r <value>] [-p <value>] [-h]
ARGUMENTS
ID Id of client
FLAGS
-d, --description=<value> Description
-h, --help Show CLI help.
-p, --homepage=<value> Homepage
-r, --redirect_uri=<value> Redirect uri
DESCRIPTION
Update a client.
See code: src/commands/client/update.ts
Add a new column
USAGE
$ gc2 column add [SCHEMA] [TABLE] [COLUMN] [TYPE] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMN Name of new column
TYPE Type of new column
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Add a new column
See code: src/commands/column/add.ts
Set default value for column
USAGE
$ gc2 column default [SCHEMA] [TABLE] [COLUMN] [DEFAULT] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMN Name of column
DEFAULT Default value. Set to 'null' for removing an already set value
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Set default value for column
See code: src/commands/column/default.ts
Drop a column
USAGE
$ gc2 column drop [SCHEMA] [TABLE] [COLUMN] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMN Name of column to drop
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop a column
See code: src/commands/column/drop.ts
Get a column
USAGE
$ gc2 column get [SCHEMA] [TABLE] [COLUMN] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMN Column
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get a column
See code: src/commands/column/get.ts
Set column to nullable
USAGE
$ gc2 column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMN Name of column
NULLABLE (true|false)
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Set column to nullable
See code: src/commands/column/nullable.ts
Rename column
USAGE
$ gc2 column rename [SCHEMA] [TABLE] [COLUMN] [NAME] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMN Existing Name of column
NAME New name for column
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Rename column
See code: src/commands/column/rename.ts
Rename column
USAGE
$ gc2 column type [SCHEMA] [TABLE] [COLUMN] [TYPE] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMN Name of column
TYPE New type for column
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Rename column
See code: src/commands/column/type.ts
Set connection. You can use flags to set host, database and user. If one or more flags are missing, you will be prompted instead.
USAGE
$ gc2 connect [-h] [-r] [-H <value>]
FLAGS
-H, --host=<value> Host
-h, --help Show CLI help.
-r, --reset Reset connection
DESCRIPTION
Set connection. You can use flags to set host, database and user. If one or more flags are missing, you will be
prompted instead.
See code: src/commands/connect.ts
Add a constraint
USAGE
$ gc2 constraint add [SCHEMA] [TABLE] [COLUMNS] [TYPE] [NAME] [-h] [-t <value>] [-e <value>] [-c <value>]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMNS Columns for use in the constraint (comma separated)
TYPE (primary|unique|foreign|check) Type of constraint
NAME Name for constraint
FLAGS
-h, --help Show CLI help.
CHECK OPTIONS FLAGS
-c, --check=<value> Check expression
FOREIGN KEY OPTIONS FLAGS
-e, --referencedColumns=<value> Referenced columns
-t, --referencedTable=<value> Referenced table
DESCRIPTION
Add a constraint
See code: src/commands/constraint/add.ts
Drop a constraint
USAGE
$ gc2 constraint drop [SCHEMA] [TABLE] [NAME] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
NAME Name for constraint
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop a constraint
See code: src/commands/constraint/drop.ts
USAGE
$ gc2 constraint get
See code: src/commands/constraint/get.ts
Drop all foreign tables in schema
USAGE
$ gc2 foreign drop SCHEMAS [INCLUDE] [-h]
ARGUMENTS
SCHEMAS schemas for dropping (comma separated)
INCLUDE only drop named foreign tables. Comma separated
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop all foreign tables in schema
See code: src/commands/foreign/drop.ts
Import schema from foreign server
USAGE
$ gc2 foreign import SERVER FROM TO [INCLUDE] [-h]
ARGUMENTS
SERVER name of foreign server
FROM comma separated list of foreign schemas
TO comma separated list of local schemas
INCLUDE only include named relations in import. Comma separated
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Import schema from foreign server
See code: src/commands/foreign/import.ts
Create mat views from foreign tables
USAGE
$ gc2 foreign materialize FROM [TO] [INCLUDE] [-h] [-p <value>] [-s <value>]
ARGUMENTS
FROM comma separated list of source schemas
TO comma separated list of target schemas
INCLUDE only include named foreign tables. Comma separated
FLAGS
-h, --help Show CLI help.
-p, --prefix=<value> prefix for created foreign tables
-s, --suffix=<value> suffix for created foreign tables
DESCRIPTION
Create mat views from foreign tables
See code: src/commands/foreign/materialize.ts
Add a fishnet grid from an input polygon.
USAGE
$ gc2 grid -t <value> -e <value> -s <value> [-h]
FLAGS
-e, --extent=<value> (required) Polygon table which should be used for extent
-h, --help Show CLI help.
-s, --size=<value> (required) Cell size in map units
-t, --table=<value> (required) Name of the new fishnet table
DESCRIPTION
Add a fishnet grid from an input polygon.
See code: src/commands/grid.ts
Display help for gc2.
USAGE
$ gc2 help [COMMANDS...] [-n]
ARGUMENTS
COMMANDS... Command to show help for.
FLAGS
-n, --nested-commands Include all nested commands in the output.
DESCRIPTION
Display help for gc2.
See code: @oclif/plugin-help
Import files to GC2. Set path to a file or folder, which will be compressed, uploaded and imported into GC2
USAGE
$ gc2 import SCHEMA PATH [-s <value>] [-t <value>] [-d] [-h]
ARGUMENTS
SCHEMA Name of user.
PATH Input path to file or folder.
FLAGS
-d, --dry_run Dry run. Only analyse files with no import.
-h, --help Show CLI help.
-s, --s_srs=<value> Source spatial reference system. Use EPSG codes.
-t, --t_srs=<value> Target spatial reference system. Use EPSG codes.
DESCRIPTION
Import files to GC2. Set path to a file or folder, which will be compressed, uploaded and imported into GC2
See code: src/commands/import.ts
Add index
USAGE
$ gc2 index add [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME] [-u] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
COLUMNS Columns to index (comma separated)
METHOD (btree|brin|gin|gist|hash) Index method
NAME Name of index
FLAGS
-h, --help Show CLI help.
-u, --unique Causes the system to check for duplicate values in the table when the index is created
DESCRIPTION
Add index
See code: src/commands/index/add.ts
Add column
USAGE
$ gc2 index drop [SCHEMA] [TABLE] [NAME] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
NAME Name of index
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Add column
See code: src/commands/index/drop.ts
USAGE
$ gc2 index get
See code: src/commands/index/get.ts
Sign in to GC2. You can set the connect options beforehand using the connect
command. Providing the password on the commandline is considered insecure. It's better to be prompt for the password
USAGE
$ gc2 login [-h] [-p <value>] [-u <value>] [-f password|device|code]
FLAGS
-f, --flow=<option> [default: code] Authentication flow
<options: password|device|code>
-h, --help Show CLI help.
-p, --password=<value> Password
-u, --user=<value> Username/database
DESCRIPTION
Sign in to GC2. You can set the connect options beforehand using the `connect` command. Providing the password on the
commandline is considered insecure. It's better to be prompt for the password
See code: src/commands/login.ts
Get privileges on table.
USAGE
$ gc2 privilege get [SCHEMA] [TABLE] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get privileges on table.
See code: src/commands/privilege/get.ts
Set privileges on table.
USAGE
$ gc2 privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGES] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
USER Name of user
PRIVILEGES Which privileges
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Set privileges on table.
See code: src/commands/privilege/set.ts
Create new rule
USAGE
$ gc2 rule add [-P <value>] [-u <value>] [-s <value>] [-p <value>] [-c <value>] [-t <value>] [-i <value>]
[-a <value>] [-f <value>] [-h]
FLAGS
-P, --priority=<value> Priority
-a, --access=<value> Access
-c, --schema=<value> schema
-f, --filter=<value> Filter
-h, --help Show CLI help.
-i, --iprange=<value> Ip range
-p, --request=<value> Request
-s, --service=<value> Service
-t, --table=<value> Table
-u, --username=<value> Username
DESCRIPTION
Create new rule
See code: src/commands/rule/add.ts
Drop a rule.
USAGE
$ gc2 rule drop [ID] [-h]
ARGUMENTS
ID Id of rule
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop a rule.
See code: src/commands/rule/drop.ts
Get rule(s).
USAGE
$ gc2 rule get [ID] [-h]
ARGUMENTS
ID Rule id
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get rule(s).
See code: src/commands/rule/get.ts
Update rule rule
USAGE
$ gc2 rule update [ID] [-p <value>] [-u <value>] [-s <value>] [-r <value>] [-c <value>] [-t <value>] [-i
<value>] [-a <value>] [-f <value>] [-h]
ARGUMENTS
ID Rule id
FLAGS
-a, --access=<value> Access
-c, --schema=<value> schema
-f, --filter=<value> Filter
-h, --help Show CLI help.
-i, --iprange=<value> Ip range
-p, --priority=<value> Priority
-r, --request=<value> Request
-s, --service=<value> Service
-t, --table=<value> Table
-u, --username=<value> Username
DESCRIPTION
Update rule rule
See code: src/commands/rule/update.ts
Starts a scheduler job
USAGE
$ gc2 scheduler start JOB [INCLUDE] [-h] [-n <value>] [-f]
ARGUMENTS
JOB job id to start. Can also be a schema name and all jobs for that schema will be started
INCLUDE only include jobs for named tables. Comma separated. Will only have effect id schema is used in "job" option
FLAGS
-f, --force force table to be recreated
-h, --help Show CLI help.
-n, --name=<value> Name the started job(s). The name will be listed in the progress status
DESCRIPTION
Starts a scheduler job
See code: src/commands/scheduler/start.ts
Get jobs in progress
USAGE
$ gc2 scheduler status [-h]
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get jobs in progress
See code: src/commands/scheduler/status.ts
Create a new schema
USAGE
$ gc2 schema add [SCHEMA] [-h]
ARGUMENTS
SCHEMA Name of new schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Create a new schema
See code: src/commands/schema/add.ts
Drop schema.
USAGE
$ gc2 schema drop [SCHEMA] [-h]
ARGUMENTS
SCHEMA Name of schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop schema.
See code: src/commands/schema/drop.ts
Get list of tables in schema.
USAGE
$ gc2 schema get [SCHEMA] [-h]
ARGUMENTS
SCHEMA Name of schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get list of tables in schema.
See code: src/commands/schema/get.ts
Rename schema
USAGE
$ gc2 schema rename [SCHEMA] [NAME] [-h]
ARGUMENTS
SCHEMA Name of schema
NAME New name for schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Rename schema
See code: src/commands/schema/rename.ts
List running seed jobs
USAGE
$ gc2 seed list [-h]
FLAGS
-h, --help Show CLI help.
DESCRIPTION
List running seed jobs
See code: src/commands/seed/list.ts
Logs
USAGE
$ gc2 seed log -u <value> [-h]
FLAGS
-h, --help Show CLI help.
-u, --uuid=<value> (required) UUID of seed job
DESCRIPTION
Logs
See code: src/commands/seed/log.ts
Starts a seed job
USAGE
$ gc2 seed start -n <value> -l <value> -g <value> -s <value> -e <value> -x <value> [-h] [-t <value>] [-f]
FLAGS
-e, --end=<value> (required) End zoom level (the higher number)
-f, --force Force seed job - overwrites existing tiles
-g, --grid=<value> (required) Grid to use
-h, --help Show CLI help.
-l, --layer=<value> (required) Layer to seed [schema].[relation]
-n, --name=<value> (required) Name of seed job
-s, --start=<value> (required) Start zoom level (the lower number)
-t, --threads=<value> Number of parallel threads that should be used to request tiles from the WMS source
-x, --extent=<value> (required) Polygon layer which set the extent for the seeding [schema].[relation]
DESCRIPTION
Starts a seed job
See code: src/commands/seed/start.ts
Stops a seed job
USAGE
$ gc2 seed stop -u <value> [-h]
FLAGS
-h, --help Show CLI help.
-u, --uuid=<value> (required) UUID of seed job
DESCRIPTION
Stops a seed job
See code: src/commands/seed/stop.ts
Run SQL statements. If run without --statement inactive mode will be enabled.
USAGE
$ gc2 sql [-s <value>] [-c <value>] [-f <value>] [-p <value>] [-h]
FLAGS
-c, --srs=<value> [default: 4326] Output spatial reference system. Use EPSG codes.
-f, --format=<value> [default: csv] Output file format.
-h, --help Show CLI help.
-p, --path=<value> [default: .] Output path to file. If omitted file is saved in current folder.
-s, --statement=<value> SQL statement
DESCRIPTION
Run SQL statements. If run without --statement inactive mode will be enabled.
See code: src/commands/sql.ts
Get usage statistics.
USAGE
$ gc2 stat [-h]
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get usage statistics.
See code: src/commands/stat.ts
Create a symbol file from a directory for use in Vidi Symbol extension
USAGE
$ gc2 symbol PATH [-h] [-f <value>]
ARGUMENTS
PATH Path to directory with SVG files
FLAGS
-f, --file=<value> Output file name. If omitted the content will be printed
-h, --help Show CLI help.
DESCRIPTION
Create a symbol file from a directory for use in Vidi Symbol extension
See code: src/commands/symbol.ts
Create a new table.
USAGE
$ gc2 table add [SCHEMA] [TABLE] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Create a new table.
See code: src/commands/table/add.ts
Drop table
USAGE
$ gc2 table drop [SCHEMA] [TABLE] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop table
See code: src/commands/table/drop.ts
Get table definition.
USAGE
$ gc2 table get [SCHEMA] [TABLE] [-h] [--columns <value> | -x] [--filter <value>] [--no-header | [--csv |
--no-truncate]] [--output csv|json|yaml | | ] [--sort <value>]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
FLAGS
-h, --help Show CLI help.
-x, --extended show extra columns
--columns=<value> only show provided columns (comma-separated)
--csv output is csv format [alias: --output=csv]
--filter=<value> filter property by partial string matching, ex: name=foo
--no-header hide table header from output
--no-truncate do not truncate output to fit screen
--output=<option> output in a more machine friendly format
<options: csv|json|yaml>
--sort=<value> property to sort by (prepend '-' for descending)
DESCRIPTION
Get table definition.
See code: src/commands/table/get.ts
Move table to another schema.
USAGE
$ gc2 table move [SCHEMA] [TABLE] [DESTINATION] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
DESTINATION Destination schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Move table to another schema.
See code: src/commands/table/move.ts
Rename table.
USAGE
$ gc2 table rename [SCHEMA] [TABLE] [NAME] [-h]
ARGUMENTS
SCHEMA Name of schema
TABLE Name of table
NAME New name for table
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Rename table.
See code: src/commands/table/rename.ts
update the gc2 CLI
USAGE
$ gc2 update [CHANNEL] [-a] [-v <value> | -i] [--force]
FLAGS
-a, --available Install a specific version.
-i, --interactive Interactively select version to install. This is ignored if a channel is provided.
-v, --version=<value> Install a specific version.
--force Force a re-download of the requested version.
DESCRIPTION
update the gc2 CLI
EXAMPLES
Update to the stable channel:
$ gc2 update stable
Update to a specific version:
$ gc2 update --version 1.0.0
Interactively select version:
$ gc2 update --interactive
See available versions:
$ gc2 update --available
See code: @oclif/plugin-update
Create new user.
USAGE
$ gc2 user add [NAME] [-h] [-p <value>] [-e <value>] [-e <value>]
ARGUMENTS
NAME Name of new user
FLAGS
-e, --email=<value> email of new user
-e, --properties=<value> properties of new user
-h, --help Show CLI help.
-p, --password=<value> password of new user
DESCRIPTION
Create new user.
See code: src/commands/user/add.ts
Drop existing user.
USAGE
$ gc2 user drop [NAME] [-h]
ARGUMENTS
NAME Name of user to drop
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop existing user.
See code: src/commands/user/drop.ts
USAGE
$ gc2 user get
See code: src/commands/user/get.ts
Update user
USAGE
$ gc2 user update [NAME] [-h] [-p <value>] [-e <value>] [-g <value>]
ARGUMENTS
NAME Name of user.
FLAGS
-e, --properties=<value> New properties
-g, --group=<value> New group
-h, --help Show CLI help.
-p, --password=<value> New password
DESCRIPTION
Update user
See code: src/commands/user/update.ts
Backup all (mat)views definitions in schema
USAGE
$ gc2 view backup SCHEMAS [-h]
ARGUMENTS
SCHEMAS schemas for backup (comma separated)
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Backup all (mat)views definitions in schema
See code: src/commands/view/backup.ts
Get "*" definitions from backup for schema
USAGE
$ gc2 view get SCHEMA [-h]
ARGUMENTS
SCHEMA get star views for schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get "*" definitions from backup for schema
See code: src/commands/view/get.ts
Refresh all materialized views in schema
USAGE
$ gc2 view refresh SCHEMAS [INCLUDE] [-h]
ARGUMENTS
SCHEMAS comma separated list of schemas
INCLUDE only include named views in restore. Comma separated
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Refresh all materialized views in schema
See code: src/commands/view/refresh.ts
Restore all (mat)views definitions from schema
USAGE
$ gc2 view restore FROM [TO] [INCLUDE] [-h]
ARGUMENTS
FROM comma separated list of source schemas
TO comma separated list of target schemas
INCLUDE only include named views in restore. Comma separated
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Restore all (mat)views definitions from schema
See code: src/commands/view/restore.ts
centia admin
centia client add [NAME]
centia client drop [ID]
centia client get [ID]
centia client update [ID]
centia column add [TABLE] [COLUMN] [TYPE]
centia column default [TABLE] [COLUMN] [DEFAULT]
centia column drop [TABLE] [COLUMN]
centia column get [TABLE] [COLUMN]
centia column nullable [TABLE] [COLUMN] [NULLABLE]
centia column rename [TABLE] [COLUMN] [NAME]
centia column type [TABLE] [COLUMN] [TYPE]
centia connect
centia constraint add [TABLE] [COLUMNS] [TYPE] [NAME]
centia constraint drop [TABLE] [NAME]
centia constraint get
centia foreign drop SCHEMAS [INCLUDE]
centia foreign import SERVER FROM TO [INCLUDE]
centia foreign materialize FROM [TO] [INCLUDE]
centia grid
centia help [COMMANDS]
centia import PATH
centia index add [TABLE] [COLUMNS] [METHOD] [NAME]
centia index drop [TABLE] [NAME]
centia index get
centia login
centia privilege get [TABLE]
centia privilege set [TABLE] [USER] [PRIVILEGES]
centia rule add
centia rule drop [ID]
centia rule get [ID]
centia rule update [ID]
centia scheduler start JOB [INCLUDE]
centia scheduler status
centia schema add [SCHEMA]
centia schema drop [SCHEMA]
centia schema get [SCHEMA]
centia schema rename [SCHEMA] [NAME]
centia seed list
centia seed log
centia seed start
centia seed stop
centia sql
centia stat
centia symbol PATH
centia table add [TABLE]
centia table drop [TABLE]
centia table get [TABLE]
centia table move [TABLE] [DESTINATION]
centia table rename [TABLE] [NAME]
centia update [CHANNEL]
centia user add [NAME]
centia user drop [NAME]
centia user get
centia user update
centia view backup SCHEMAS
centia view get SCHEMA
centia view refresh SCHEMAS [INCLUDE]
centia view restore FROM [TO] [INCLUDE]
Run administration task on the GC2 installation.
USAGE
$ centia admin -t
mapfiles|mapcachefile|qgisfiles|schema|migrations|diskcleanup|cachestats|cachecleanup|insertmeta
FLAGS
-t, --task=<option> (required) The task to run
<options:
mapfiles|mapcachefile|qgisfiles|schema|migrations|diskcleanup|cachestats|cachecleanup|insertmeta>
DESCRIPTION
Run administration task on the GC2 installation.
See code: src/commands/admin.ts
Create new client
USAGE
$ centia client add [NAME] [-n <value>] [-d <value>] [-r <value>] [-p <value>] [-h]
ARGUMENTS
NAME Name of new client
FLAGS
-d, --description=<value> Description
-h, --help Show CLI help.
-n, --name=<value> Name
-p, --homepage=<value> Homepage
-r, --redirect_uri=<value> Redirect uri
DESCRIPTION
Create new client
See code: src/commands/client/add.ts
Drop a client.
USAGE
$ centia client drop [ID] [-h]
ARGUMENTS
ID Id of client
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop a client.
See code: src/commands/client/drop.ts
Get client(s).
USAGE
$ centia client get [ID] [-h]
ARGUMENTS
ID Client id
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get client(s).
See code: src/commands/client/get.ts
Update a client.
USAGE
$ centia client update [ID] [-d <value>] [-r <value>] [-p <value>] [-h]
ARGUMENTS
ID Id of client
FLAGS
-d, --description=<value> Description
-h, --help Show CLI help.
-p, --homepage=<value> Homepage
-r, --redirect_uri=<value> Redirect uri
DESCRIPTION
Update a client.
See code: src/commands/client/update.ts
Add a new column
USAGE
$ centia column add [TABLE] [COLUMN] [TYPE] [-h]
ARGUMENTS
TABLE Name of table
COLUMN Name of new column
TYPE Type of new column
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Add a new column
See code: src/commands/column/add.ts
Set default value for column
USAGE
$ centia column default [TABLE] [COLUMN] [DEFAULT] [-h]
ARGUMENTS
TABLE Name of table
COLUMN Name of column
DEFAULT Default value. Set to 'null' for removing an already set value
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Set default value for column
See code: src/commands/column/default.ts
Drop a column
USAGE
$ centia column drop [TABLE] [COLUMN] [-h]
ARGUMENTS
TABLE Name of table
COLUMN Name of column to drop
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop a column
See code: src/commands/column/drop.ts
Get a column
USAGE
$ centia column get [TABLE] [COLUMN] [-h]
ARGUMENTS
TABLE Name of table
COLUMN Column
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get a column
See code: src/commands/column/get.ts
Set column to nullable
USAGE
$ centia column nullable [TABLE] [COLUMN] [NULLABLE] [-h]
ARGUMENTS
TABLE Name of table
COLUMN Name of column
NULLABLE (true|false)
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Set column to nullable
See code: src/commands/column/nullable.ts
Rename column
USAGE
$ centia column rename [TABLE] [COLUMN] [NAME] [-h]
ARGUMENTS
TABLE Name of table
COLUMN Existing Name of column
NAME New name for column
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Rename column
See code: src/commands/column/rename.ts
Rename column
USAGE
$ centia column type [TABLE] [COLUMN] [TYPE] [-h]
ARGUMENTS
TABLE Name of table
COLUMN Name of column
TYPE New type for column
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Rename column
See code: src/commands/column/type.ts
Set connection. You can use flags to set host, database and user. If one or more flags are missing, you will be prompted instead.
USAGE
$ centia connect [-h] [-r] [-H <value>]
FLAGS
-H, --host=<value> Host
-h, --help Show CLI help.
-r, --reset Reset connection
DESCRIPTION
Set connection. You can use flags to set host, database and user. If one or more flags are missing, you will be
prompted instead.
See code: src/commands/connect.ts
Add a constraint
USAGE
$ centia constraint add [TABLE] [COLUMNS] [TYPE] [NAME] [-h] [-t <value>] [-e <value>] [-c <value>]
ARGUMENTS
TABLE Name of table
COLUMNS Columns for use in the constraint (comma separated)
TYPE (primary|unique|foreign|check) Type of constraint
NAME Name for constraint
FLAGS
-h, --help Show CLI help.
CHECK OPTIONS FLAGS
-c, --check=<value> Check expression
FOREIGN KEY OPTIONS FLAGS
-e, --referencedColumns=<value> Referenced columns
-t, --referencedTable=<value> Referenced table
DESCRIPTION
Add a constraint
See code: src/commands/constraint/add.ts
Drop a constraint
USAGE
$ centia constraint drop [TABLE] [NAME] [-h]
ARGUMENTS
TABLE Name of table
NAME Name for constraint
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop a constraint
See code: src/commands/constraint/drop.ts
USAGE
$ centia constraint get
See code: src/commands/constraint/get.ts
Drop all foreign tables in schema
USAGE
$ centia foreign drop SCHEMAS [INCLUDE] [-h]
ARGUMENTS
SCHEMAS schemas for dropping (comma separated)
INCLUDE only drop named foreign tables. Comma separated
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop all foreign tables in schema
See code: src/commands/foreign/drop.ts
Import schema from foreign server
USAGE
$ centia foreign import SERVER FROM TO [INCLUDE] [-h]
ARGUMENTS
SERVER name of foreign server
FROM comma separated list of foreign schemas
TO comma separated list of local schemas
INCLUDE only include named relations in import. Comma separated
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Import schema from foreign server
See code: src/commands/foreign/import.ts
Create mat views from foreign tables
USAGE
$ centia foreign materialize FROM [TO] [INCLUDE] [-h] [-p <value>] [-s <value>]
ARGUMENTS
FROM comma separated list of source schemas
TO comma separated list of target schemas
INCLUDE only include named foreign tables. Comma separated
FLAGS
-h, --help Show CLI help.
-p, --prefix=<value> prefix for created foreign tables
-s, --suffix=<value> suffix for created foreign tables
DESCRIPTION
Create mat views from foreign tables
See code: src/commands/foreign/materialize.ts
Add a fishnet grid from an input polygon.
USAGE
$ centia grid -t <value> -e <value> -s <value> [-h]
FLAGS
-e, --extent=<value> (required) Polygon table which should be used for extent
-h, --help Show CLI help.
-s, --size=<value> (required) Cell size in map units
-t, --table=<value> (required) Name of the new fishnet table
DESCRIPTION
Add a fishnet grid from an input polygon.
See code: src/commands/grid.ts
Display help for centia.
USAGE
$ centia help [COMMANDS...] [-n]
ARGUMENTS
COMMANDS... Command to show help for.
FLAGS
-n, --nested-commands Include all nested commands in the output.
DESCRIPTION
Display help for centia.
See code: @oclif/plugin-help
Import files to GC2. Set path to a file or folder, which will be compressed, uploaded and imported into GC2
USAGE
$ centia import PATH [-s <value>] [-t <value>] [-d] [-h]
ARGUMENTS
PATH Input path to file or folder.
FLAGS
-d, --dry_run Dry run. Only analyse files with no import.
-h, --help Show CLI help.
-s, --s_srs=<value> Source spatial reference system. Use EPSG codes.
-t, --t_srs=<value> Target spatial reference system. Use EPSG codes.
DESCRIPTION
Import files to GC2. Set path to a file or folder, which will be compressed, uploaded and imported into GC2
See code: src/commands/import.ts
Add index
USAGE
$ centia index add [TABLE] [COLUMNS] [METHOD] [NAME] [-u] [-h]
ARGUMENTS
TABLE Name of table
COLUMNS Columns to index (comma separated)
METHOD (btree|brin|gin|gist|hash) Index method
NAME Name of index
FLAGS
-h, --help Show CLI help.
-u, --unique Causes the system to check for duplicate values in the table when the index is created
DESCRIPTION
Add index
See code: src/commands/index/add.ts
Add column
USAGE
$ centia index drop [TABLE] [NAME] [-h]
ARGUMENTS
TABLE Name of table
NAME Name of index
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Add column
See code: src/commands/index/drop.ts
USAGE
$ centia index get
See code: src/commands/index/get.ts
Sign in to GC2. You can set the connect options beforehand using the connect
command. Providing the password on the commandline is considered insecure. It's better to be prompt for the password
USAGE
$ centia login [-h] [-p <value>] [-u <value>] [-f password|device|code]
FLAGS
-f, --flow=<option> [default: code] Authentication flow
<options: password|device|code>
-h, --help Show CLI help.
-p, --password=<value> Password
-u, --user=<value> Username/database
DESCRIPTION
Sign in to GC2. You can set the connect options beforehand using the `connect` command. Providing the password on the
commandline is considered insecure. It's better to be prompt for the password
See code: src/commands/login.ts
Get privileges on table.
USAGE
$ centia privilege get [TABLE] [-h]
ARGUMENTS
TABLE Name of table
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get privileges on table.
See code: src/commands/privilege/get.ts
Set privileges on table.
USAGE
$ centia privilege set [TABLE] [USER] [PRIVILEGES] [-h]
ARGUMENTS
TABLE Name of table
USER Name of user
PRIVILEGES Which privileges
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Set privileges on table.
See code: src/commands/privilege/set.ts
Create new rule
USAGE
$ centia rule add [-P <value>] [-u <value>] [-s <value>] [-p <value>] [-c <value>] [-t <value>] [-i <value>]
[-a <value>] [-f <value>] [-h]
FLAGS
-P, --priority=<value> Priority
-a, --access=<value> Access
-c, --schema=<value> schema
-f, --filter=<value> Filter
-h, --help Show CLI help.
-i, --iprange=<value> Ip range
-p, --request=<value> Request
-s, --service=<value> Service
-t, --table=<value> Table
-u, --username=<value> Username
DESCRIPTION
Create new rule
See code: src/commands/rule/add.ts
Drop a rule.
USAGE
$ centia rule drop [ID] [-h]
ARGUMENTS
ID Id of rule
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop a rule.
See code: src/commands/rule/drop.ts
Get rule(s).
USAGE
$ centia rule get [ID] [-h]
ARGUMENTS
ID Rule id
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get rule(s).
See code: src/commands/rule/get.ts
Update rule rule
USAGE
$ centia rule update [ID] [-p <value>] [-u <value>] [-s <value>] [-r <value>] [-c <value>] [-t <value>] [-i
<value>] [-a <value>] [-f <value>] [-h]
ARGUMENTS
ID Rule id
FLAGS
-a, --access=<value> Access
-c, --schema=<value> schema
-f, --filter=<value> Filter
-h, --help Show CLI help.
-i, --iprange=<value> Ip range
-p, --priority=<value> Priority
-r, --request=<value> Request
-s, --service=<value> Service
-t, --table=<value> Table
-u, --username=<value> Username
DESCRIPTION
Update rule rule
See code: src/commands/rule/update.ts
Starts a scheduler job
USAGE
$ centia scheduler start JOB [INCLUDE] [-h] [-n <value>] [-f]
ARGUMENTS
JOB job id to start. Can also be a schema name and all jobs for that schema will be started
INCLUDE only include jobs for named tables. Comma separated. Will only have effect id schema is used in "job" option
FLAGS
-f, --force force table to be recreated
-h, --help Show CLI help.
-n, --name=<value> Name the started job(s). The name will be listed in the progress status
DESCRIPTION
Starts a scheduler job
See code: src/commands/scheduler/start.ts
Get jobs in progress
USAGE
$ centia scheduler status [-h]
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get jobs in progress
See code: src/commands/scheduler/status.ts
Create a new schema
USAGE
$ centia schema add [SCHEMA] [-h]
ARGUMENTS
SCHEMA Name of new schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Create a new schema
See code: src/commands/schema/add.ts
Drop schema.
USAGE
$ centia schema drop [SCHEMA] [-h]
ARGUMENTS
SCHEMA Name of schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop schema.
See code: src/commands/schema/drop.ts
Get list of tables in schema.
USAGE
$ centia schema get [SCHEMA] [-h]
ARGUMENTS
SCHEMA Name of schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get list of tables in schema.
See code: src/commands/schema/get.ts
Rename schema
USAGE
$ centia schema rename [SCHEMA] [NAME] [-h]
ARGUMENTS
SCHEMA Name of schema
NAME New name for schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Rename schema
See code: src/commands/schema/rename.ts
List running seed jobs
USAGE
$ centia seed list [-h]
FLAGS
-h, --help Show CLI help.
DESCRIPTION
List running seed jobs
See code: src/commands/seed/list.ts
Logs
USAGE
$ centia seed log -u <value> [-h]
FLAGS
-h, --help Show CLI help.
-u, --uuid=<value> (required) UUID of seed job
DESCRIPTION
Logs
See code: src/commands/seed/log.ts
Starts a seed job
USAGE
$ centia seed start -n <value> -l <value> -g <value> -s <value> -e <value> -x <value> [-h] [-t <value>] [-f]
FLAGS
-e, --end=<value> (required) End zoom level (the higher number)
-f, --force Force seed job - overwrites existing tiles
-g, --grid=<value> (required) Grid to use
-h, --help Show CLI help.
-l, --layer=<value> (required) Layer to seed [schema].[relation]
-n, --name=<value> (required) Name of seed job
-s, --start=<value> (required) Start zoom level (the lower number)
-t, --threads=<value> Number of parallel threads that should be used to request tiles from the WMS source
-x, --extent=<value> (required) Polygon layer which set the extent for the seeding [schema].[relation]
DESCRIPTION
Starts a seed job
See code: src/commands/seed/start.ts
Stops a seed job
USAGE
$ centia seed stop -u <value> [-h]
FLAGS
-h, --help Show CLI help.
-u, --uuid=<value> (required) UUID of seed job
DESCRIPTION
Stops a seed job
See code: src/commands/seed/stop.ts
Run SQL statements. If run without --statement inactive mode will be enabled.
USAGE
$ centia sql [-s <value>] [-c <value>] [-f <value>] [-p <value>] [-h]
FLAGS
-c, --srs=<value> [default: 4326] Output spatial reference system. Use EPSG codes.
-f, --format=<value> [default: csv] Output file format.
-h, --help Show CLI help.
-p, --path=<value> [default: .] Output path to file. If omitted file is saved in current folder.
-s, --statement=<value> SQL statement
DESCRIPTION
Run SQL statements. If run without --statement inactive mode will be enabled.
See code: src/commands/sql.ts
Get usage statistics.
USAGE
$ centia stat [-h]
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get usage statistics.
See code: src/commands/stat.ts
Create a symbol file from a directory for use in Vidi Symbol extension
USAGE
$ centia symbol PATH [-h] [-f <value>]
ARGUMENTS
PATH Path to directory with SVG files
FLAGS
-f, --file=<value> Output file name. If omitted the content will be printed
-h, --help Show CLI help.
DESCRIPTION
Create a symbol file from a directory for use in Vidi Symbol extension
See code: src/commands/symbol.ts
Create a new table.
USAGE
$ centia table add [TABLE] [-h]
ARGUMENTS
TABLE Name of table
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Create a new table.
See code: src/commands/table/add.ts
Drop table
USAGE
$ centia table drop [TABLE] [-h]
ARGUMENTS
TABLE Name of table
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop table
See code: src/commands/table/drop.ts
Get table definition.
USAGE
$ centia table get [TABLE] [-h] [--columns <value> | -x] [--filter <value>] [--no-header | [--csv |
--no-truncate]] [--output csv|json|yaml | | ] [--sort <value>]
ARGUMENTS
TABLE Name of table
FLAGS
-h, --help Show CLI help.
-x, --extended show extra columns
--columns=<value> only show provided columns (comma-separated)
--csv output is csv format [alias: --output=csv]
--filter=<value> filter property by partial string matching, ex: name=foo
--no-header hide table header from output
--no-truncate do not truncate output to fit screen
--output=<option> output in a more machine friendly format
<options: csv|json|yaml>
--sort=<value> property to sort by (prepend '-' for descending)
DESCRIPTION
Get table definition.
See code: src/commands/table/get.ts
Move table to another schema.
USAGE
$ centia table move [TABLE] [DESTINATION] [-h]
ARGUMENTS
TABLE Name of table
DESTINATION Destination schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Move table to another schema.
See code: src/commands/table/move.ts
Rename table.
USAGE
$ centia table rename [TABLE] [NAME] [-h]
ARGUMENTS
TABLE Name of table
NAME New name for table
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Rename table.
See code: src/commands/table/rename.ts
update the centia CLI
USAGE
$ centia update [CHANNEL] [-a] [-v <value> | -i] [--force]
FLAGS
-a, --available Install a specific version.
-i, --interactive Interactively select version to install. This is ignored if a channel is provided.
-v, --version=<value> Install a specific version.
--force Force a re-download of the requested version.
DESCRIPTION
update the centia CLI
EXAMPLES
Update to the stable channel:
$ centia update stable
Update to a specific version:
$ centia update --version 1.0.0
Interactively select version:
$ centia update --interactive
See available versions:
$ centia update --available
See code: @oclif/plugin-update
Create new user.
USAGE
$ centia user add [NAME] [-h] [-p <value>] [-e <value>] [-e <value>]
ARGUMENTS
NAME Name of new user
FLAGS
-e, --email=<value> email of new user
-e, --properties=<value> properties of new user
-h, --help Show CLI help.
-p, --password=<value> password of new user
DESCRIPTION
Create new user.
See code: src/commands/user/add.ts
Drop existing user.
USAGE
$ centia user drop [NAME] [-h]
ARGUMENTS
NAME Name of user to drop
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Drop existing user.
See code: src/commands/user/drop.ts
USAGE
$ centia user get
See code: src/commands/user/get.ts
Update user
USAGE
$ centia user update [-h] [-p <value>]
FLAGS
-h, --help Show CLI help.
-p, --password=<value> New password
DESCRIPTION
Update user
See code: src/commands/user/update.ts
Backup all (mat)views definitions in schema
USAGE
$ centia view backup SCHEMAS [-h]
ARGUMENTS
SCHEMAS schemas for backup (comma separated)
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Backup all (mat)views definitions in schema
See code: src/commands/view/backup.ts
Get "*" definitions from backup for schema
USAGE
$ centia view get SCHEMA [-h]
ARGUMENTS
SCHEMA get star views for schema
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get "*" definitions from backup for schema
See code: src/commands/view/get.ts
Refresh all materialized views in schema
USAGE
$ centia view refresh SCHEMAS [INCLUDE] [-h]
ARGUMENTS
SCHEMAS comma separated list of schemas
INCLUDE only include named views in restore. Comma separated
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Refresh all materialized views in schema
See code: src/commands/view/refresh.ts
Restore all (mat)views definitions from schema
USAGE
$ centia view restore FROM [TO] [INCLUDE] [-h]
ARGUMENTS
FROM comma separated list of source schemas
TO comma separated list of target schemas
INCLUDE only include named views in restore. Comma separated
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Restore all (mat)views definitions from schema
See code: src/commands/view/restore.ts