gc2 v2024.10.2
gc2-cli
CLI tool for GC2
Usage
$ 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
...
Commands
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]
gc2 admin
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
gc2 client add [NAME]
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
gc2 client drop [ID]
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
gc2 client get [ID]
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
gc2 client update [ID]
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
gc2 column add [SCHEMA] [TABLE] [COLUMN] [TYPE]
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
gc2 column default [SCHEMA] [TABLE] [COLUMN] [DEFAULT]
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
gc2 column drop [SCHEMA] [TABLE] [COLUMN]
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
gc2 column get [SCHEMA] [TABLE] [COLUMN]
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
gc2 column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE]
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
gc2 column rename [SCHEMA] [TABLE] [COLUMN] [NAME]
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
gc2 column type [SCHEMA] [TABLE] [COLUMN] [TYPE]
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
gc2 connect
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
gc2 constraint add [SCHEMA] [TABLE] [COLUMNS] [TYPE] [NAME]
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
gc2 constraint drop [SCHEMA] [TABLE] [NAME]
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
gc2 constraint get
USAGE
$ gc2 constraint get
See code: src/commands/constraint/get.ts
gc2 foreign drop SCHEMAS [INCLUDE]
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
gc2 foreign import SERVER FROM TO [INCLUDE]
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
gc2 foreign materialize FROM [TO] [INCLUDE]
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
gc2 grid
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
gc2 help [COMMANDS]
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
gc2 import SCHEMA PATH
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
gc2 index add [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME]
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
gc2 index drop [SCHEMA] [TABLE] [NAME]
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
gc2 index get
USAGE
$ gc2 index get
See code: src/commands/index/get.ts
gc2 login
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
gc2 privilege get [SCHEMA] [TABLE]
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
gc2 privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGES]
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
gc2 rule add
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
gc2 rule drop [ID]
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
gc2 rule get [ID]
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
gc2 rule update [ID]
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
gc2 scheduler start JOB [INCLUDE]
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
gc2 scheduler status
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
gc2 schema add [SCHEMA]
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
gc2 schema drop [SCHEMA]
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
gc2 schema get [SCHEMA]
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
gc2 schema rename [SCHEMA] [NAME]
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
gc2 seed list
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
gc2 seed log
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
gc2 seed start
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
gc2 seed stop
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
gc2 sql
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
gc2 stat
Get usage statistics.
USAGE
$ gc2 stat [-h]
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get usage statistics.
See code: src/commands/stat.ts
gc2 symbol PATH
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
gc2 table add [SCHEMA] [TABLE]
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
gc2 table drop [SCHEMA] [TABLE]
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
gc2 table get [SCHEMA] [TABLE]
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
gc2 table move [SCHEMA] [TABLE] [DESTINATION]
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
gc2 table rename [SCHEMA] [TABLE] [NAME]
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
gc2 update [CHANNEL]
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
gc2 user add [NAME]
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
gc2 user drop [NAME]
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
gc2 user get
USAGE
$ gc2 user get
See code: src/commands/user/get.ts
gc2 user update [NAME]
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
gc2 view backup SCHEMAS
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
gc2 view get SCHEMA
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
gc2 view refresh SCHEMAS [INCLUDE]
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
gc2 view restore FROM [TO] [INCLUDE]
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]
centia admin
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
centia client add [NAME]
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
centia client drop [ID]
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
centia client get [ID]
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
centia client update [ID]
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
centia column add [TABLE] [COLUMN] [TYPE]
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
centia column default [TABLE] [COLUMN] [DEFAULT]
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
centia column drop [TABLE] [COLUMN]
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
centia column get [TABLE] [COLUMN]
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
centia column nullable [TABLE] [COLUMN] [NULLABLE]
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
centia column rename [TABLE] [COLUMN] [NAME]
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
centia column type [TABLE] [COLUMN] [TYPE]
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
centia connect
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
centia constraint add [TABLE] [COLUMNS] [TYPE] [NAME]
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
centia constraint drop [TABLE] [NAME]
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
centia constraint get
USAGE
$ centia constraint get
See code: src/commands/constraint/get.ts
centia foreign drop SCHEMAS [INCLUDE]
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
centia foreign import SERVER FROM TO [INCLUDE]
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
centia foreign materialize FROM [TO] [INCLUDE]
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
centia grid
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
centia help [COMMANDS]
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
centia import PATH
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
centia index add [TABLE] [COLUMNS] [METHOD] [NAME]
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
centia index drop [TABLE] [NAME]
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
centia index get
USAGE
$ centia index get
See code: src/commands/index/get.ts
centia login
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
centia privilege get [TABLE]
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
centia privilege set [TABLE] [USER] [PRIVILEGES]
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
centia rule add
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
centia rule drop [ID]
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
centia rule get [ID]
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
centia rule update [ID]
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
centia scheduler start JOB [INCLUDE]
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
centia scheduler status
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
centia schema add [SCHEMA]
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
centia schema drop [SCHEMA]
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
centia schema get [SCHEMA]
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
centia schema rename [SCHEMA] [NAME]
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
centia seed list
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
centia seed log
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
centia seed start
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
centia seed stop
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
centia sql
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
centia stat
Get usage statistics.
USAGE
$ centia stat [-h]
FLAGS
-h, --help Show CLI help.
DESCRIPTION
Get usage statistics.
See code: src/commands/stat.ts
centia symbol PATH
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
centia table add [TABLE]
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
centia table drop [TABLE]
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
centia table get [TABLE]
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
centia table move [TABLE] [DESTINATION]
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
centia table rename [TABLE] [NAME]
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
centia update [CHANNEL]
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
centia user add [NAME]
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
centia user drop [NAME]
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
centia user get
USAGE
$ centia user get
See code: src/commands/user/get.ts
centia user update
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
centia view backup SCHEMAS
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
centia view get SCHEMA
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
centia view refresh SCHEMAS [INCLUDE]
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
centia view restore FROM [TO] [INCLUDE]
Restore all (mat)views definitions from schema
USAGE
$ centia view restore FROM [TO] [INCLUDE]
8 months ago
8 months ago
8 months ago
12 months ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago
3 years ago