gc2-cli

CLI tool for GC2

• Usage
• Commands

• Usage
• Commands

• Usage
• Commands

• Usage
• Commands

• Usage
• Commands

Usage

$ npm install -g @centia/cli
$ centia COMMAND
running command...
$ centia (--version|-v)
@centia/cli/2025.9.3 linux-x64 node-v20.19.1
$ centia --help [COMMAND]
USAGE
  $ centia COMMAND
...

$ npm install -g @centia/cli
$ centia COMMAND
running command...
$ centia (--version|-v)
@centia/cli/2025.9.1 linux-x64 node-v20.19.1
$ centia --help [COMMAND]
USAGE
  $ centia COMMAND
...

$ npm install -g @mapcentia/gc2-cli
$ gc2 COMMAND
running command...
$ gc2 (--version|-v)
@mapcentia/gc2-cli/2025.2.0 linux-x64 node-v20.18.0
$ gc2 --help [COMMAND]
USAGE
  $ gc2 COMMAND
...

$ npm install -g @mapcentia/gc2-cli
$ gc2 COMMAND
running command...
$ gc2 (--version|-v)
@mapcentia/gc2-cli/2024.12.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

• centia client add [NAME]
• centia client drop [ID]
• centia client list [ID]
• centia client update [ID]
• centia column add [SCHEMA] [TABLE] [COLUMN] [TYPE]
• centia column default [SCHEMA] [TABLE] [COLUMN] [DEFAULT]
• centia column drop [SCHEMA] [TABLE] [COLUMN]
• centia column get [SCHEMA] [TABLE] [COLUMN]
• centia column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE]
• centia column rename [SCHEMA] [TABLE] [COLUMN] [NAME]
• centia column type [SCHEMA] [TABLE] [COLUMN] [TYPE]
• centia constraint add [SCHEMA] [TABLE] [COLUMNS] [TYPE] [NAME]
• centia constraint drop [SCHEMA] [TABLE] [NAME]
• centia constraint get [SCHEMA] [TABLE] [NAME]
• centia help [COMMAND]
• centia import [PATH] [SCHEMA]
• centia index add [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME]
• centia index drop [SCHEMA] [TABLE] [NAME]
• centia index get [SCHEMA] [TABLE] [NAME]
• centia login
• centia logout
• centia privilege get [SCHEMA] [TABLE]
• centia privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGE]
• centia rule add
• centia rule drop [ID]
• centia rule get [ID]
• centia rule update [ID]
• centia schema add [SCHEMA]
• centia schema drop [SCHEMA]
• centia schema get [SCHEMA]
• centia schema rename [SCHEMA] [NAME]
• centia sql
• centia table add [SCHEMA] [TABLE]
• centia table drop [SCHEMA] [TABLE]
• centia table get [SCHEMA] [TABLE]
• centia table move [SCHEMA] [TABLE] [DESTINATION]
• centia table rename [SCHEMA] [TABLE] [NAME]
• centia user add [NAME]
• centia user drop [NAME]
• centia user get [ID]
• centia user update [NAME]

centia client add [NAME]

Create new client.

USAGE
  $ centia client add [NAME] [-i <value>] [-n <value>] [-d <value>] [-r <value>] [-H <value>] [-p] [-c] [-t] [-h]

ARGUMENTS
  NAME  Name of new client.

FLAGS
  -H, --homepage=<value>      Homepage of the application.
  -c, --confirm               Client user must confirm the token exchange.
  -d, --description=<value>   Description of new client.
  -h, --help                  Show CLI help.
  -i, --id=<value>            Id of new client.
  -n, --name=<value>          Name of new client.
  -p, --public                Public client. No secret needed.
  -r, --redirect_uri=<value>  Redirect uri. Redirects will only be allowed to an uri in this list.
  -t, --two_factor            Client user must authenticate with two factor authentication.

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 list [ID]

List client(s).

USAGE
  $ centia client list [ID] [-h]

ARGUMENTS
  ID  Client id

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List client(s).

See code: src/commands/client/list.ts

centia client update [ID]

Update a client.

USAGE
  $ centia client update [ID] [-n <value>] [-d <value>] [-r <value>] [-p <value>] [-p] [-c] [-t] [-h]

ARGUMENTS
  ID  Id of client.

FLAGS
  -c, --confirm               Client user must confirm the token exchange.
  -d, --description=<value>   Description of new client.
  -h, --help                  Show CLI help.
  -n, --name=<value>          New name ofclient.
  -p, --homepage=<value>      Homepage of the application.
  -p, --public                Public client. No secret needed.
  -r, --redirect_uri=<value>  Redirect uri. Redirects will only be allowed to an uri in this list.
  -t, --two_factor            Client user must authenticate with two factor authentication.

DESCRIPTION
  Update a client.

See code: src/commands/client/update.ts

centia column add [SCHEMA] [TABLE] [COLUMN] [TYPE]

Add a new column to a table.

USAGE
  $ centia column add [SCHEMA] [TABLE] [COLUMN] [TYPE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of new column.
  TYPE    Data type of new column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Add a new column to a table.

See code: src/commands/column/add.ts

centia column default [SCHEMA] [TABLE] [COLUMN] [DEFAULT]

Set default value for column. The default value is set when inserting a new row without a value for the column.

USAGE
  $ centia 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. The default value is set when inserting a new row without a value for the column.

See code: src/commands/column/default.ts

centia column drop [SCHEMA] [TABLE] [COLUMN]

Drop a column from table.

USAGE
  $ centia 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 from table.

See code: src/commands/column/drop.ts

centia column get [SCHEMA] [TABLE] [COLUMN]

Get description of a column.

USAGE
  $ centia column get [SCHEMA] [TABLE] [COLUMN] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Get description of a column.

See code: src/commands/column/get.ts

centia column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE]

Set nullable on column. If set the column can't be empty.

USAGE
  $ centia column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE] [-h]

ARGUMENTS
  SCHEMA    Name of schema.
  TABLE     Name of table.
  COLUMN    Name of column.
  NULLABLE  (true|false) Set column to nullable.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Set nullable on column. If set the column can't be empty.

See code: src/commands/column/nullable.ts

centia column rename [SCHEMA] [TABLE] [COLUMN] [NAME]

Rename a column.

USAGE
  $ centia 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 a column.

See code: src/commands/column/rename.ts

centia column type [SCHEMA] [TABLE] [COLUMN] [TYPE]

Set the data on column. It might be, the existing data type can't be transformed to the chosen one.

USAGE
  $ centia column type [SCHEMA] [TABLE] [COLUMN] [TYPE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of column.
  TYPE    New data type for column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Set the data on column. It might be, the existing data type can't be transformed to the chosen one.

See code: src/commands/column/type.ts

centia constraint add [SCHEMA] [TABLE] [COLUMNS] [TYPE] [NAME]

Add a constraint.

USAGE
  $ centia 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

centia constraint drop [SCHEMA] [TABLE] [NAME]

Drop a constraint.

USAGE
  $ centia constraint drop [SCHEMA] [TABLE] [NAME] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  NAME    Name of constraint.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Drop a constraint.

See code: src/commands/constraint/drop.ts

centia constraint get [SCHEMA] [TABLE] [NAME]

Get constraint details.

USAGE
  $ centia constraint get [SCHEMA] [TABLE] [NAME] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  NAME    Name of constraint.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Get constraint details.

See code: src/commands/constraint/get.ts

centia help [COMMAND]

Display help for centia.

USAGE
  $ centia help [COMMAND...] [-n]

ARGUMENTS
  COMMAND...  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] [SCHEMA]

Import files. Set path to a file or folder, which will be compressed, uploaded and imported into GC2.

USAGE
  $ centia import [PATH] [SCHEMA] [-s <value>] [-t <value>] [-T <value>] [-x <value>] [-y <value>] [-d] [-a]
    [-r] [-p] [-n <value>] [-h]

ARGUMENTS
  PATH    [default: .] Input path to file or folder.
  SCHEMA  Destination schema.

FLAGS
  -T, --timestamp=<value>         Name of timestamp field. Create a timestamp field in the import table. Omit argument
                                  for no timestamp field.
  -a, --append                    Append to existing table instead of creating new.
  -d, --dry_run                   Dry run. Only analyse files with no import.
  -h, --help                      Show CLI help.
  -n, --table_name=<value>        Name of table. Defaults to the name of the file. Can only be used when importing
                                  single file - not directories unless --append is used
  -p, --p_multi                   Promote single geometries to multi part.
  -r, --truncate                  Truncate table before appending. Only have effect if --append is set.
  -s, --s_srs=<value>             Fallback source SRS. Will be used if file doesn't contain projection information
  -t, --t_srs=<value>             Fallback target SRS. Will be used if no authority name/code is available. Defaults to
                                  EPSG:4326.
  -x, --x_possible_names=<value>  Specify the potential names of the columns that can contain X/longitude. Only effects
                                  CSV. Defaults to "lon*,Lon*,x,X"]
  -y, --y_possible_names=<value>  Specify the potential names of the columns that can contain Y/latitude. Only effects
                                  CSV. Defaults to "lat*,Lat*,y,Y"]

DESCRIPTION
  Import files. 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 [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME]

Add an new index to table.

USAGE
  $ centia index add [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME] [-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 new index.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Add an new index to table.

See code: src/commands/index/add.ts

centia index drop [SCHEMA] [TABLE] [NAME]

Drop an index from table.

USAGE
  $ centia 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
  Drop an index from table.

See code: src/commands/index/drop.ts

centia index get [SCHEMA] [TABLE] [NAME]

Get index definition.

USAGE
  $ centia index get [SCHEMA] [TABLE] [NAME] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  NAME    Name of index.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Get index definition.

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 logout

Logout the current user.

USAGE
  $ centia logout [-h]

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Logout the current user.

See code: src/commands/logout.ts

centia privilege get [SCHEMA] [TABLE]

Get user privileges on table.

USAGE
  $ centia privilege get [SCHEMA] [TABLE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Get user privileges on table.

See code: src/commands/privilege/get.ts

centia privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGE]

Set user privileges on table.

USAGE
  $ centia privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGE] [-h]

ARGUMENTS
  SCHEMA     Name of schema.
  TABLE      Name of table.
  USER       Name of user.
  PRIVILEGE  Which privilege.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Set user privileges on table.

See code: src/commands/privilege/set.ts

centia rule add

Create a 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 a 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 a 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 a rule.

See code: src/commands/rule/update.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 a schema.

USAGE
  $ centia schema drop [SCHEMA] [-h]

ARGUMENTS
  SCHEMA  Name of schema.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Drop a 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 sql

Run SQL statements. If run without --statement inactive mode will be enabled.

USAGE
  $ centia sql [-s <value>] [-c <value>] [-f <value>] [-g wkt|geojson] [-p <value>] [-h]

FLAGS
  -c, --srs=<value>         [default: 4326] Output spatial reference system. Use EPSG codes.
  -f, --format=<value>      Output file format.
  -g, --geoformat=<option>  Output geometry in CSV and Excel.
                            <options: wkt|geojson>
  -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. Any select, insert, update and delete. No altering of schema is allowed.

DESCRIPTION
  Run SQL statements. If run without --statement inactive mode will be enabled.

See code: src/commands/sql.ts

centia table add [SCHEMA] [TABLE]

Create a new table.

USAGE
  $ centia 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

centia table drop [SCHEMA] [TABLE]

Drop a table.

USAGE
  $ centia table drop [SCHEMA] [TABLE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Drop a table.

See code: src/commands/table/drop.ts

centia table get [SCHEMA] [TABLE]

Get table definition.

USAGE
  $ centia table get [SCHEMA] [TABLE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Get table definition.

See code: src/commands/table/get.ts

centia table move [SCHEMA] [TABLE] [DESTINATION]

Move table to another schema.

USAGE
  $ centia 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

centia table rename [SCHEMA] [TABLE] [NAME]

Rename table.

USAGE
  $ centia 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

centia user add [NAME]

Create new user.

USAGE
  $ centia user add [NAME] [-h] [-p <value>] [-e <value>] [-P <value>] [-d]

ARGUMENTS
  NAME  Name of new user

FLAGS
  -P, --properties=<value>  Properties for new user
  -d, --default_user        The default user is the user that is used when no token is provided. Use for public
                            applications where users should not be able to access data without a token.
  -e, --email=<value>       E-mail for new user
  -h, --help                Show CLI help.
  -p, --password=<value>    password for 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 [ID]

Get user(s).

USAGE
  $ centia user get [ID] [-h]

ARGUMENTS
  ID  User id

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Get user(s).

See code: src/commands/user/get.ts

centia user update [NAME]

Update user.

USAGE
  $ centia user update [NAME] [-h] [-p <value>] [-d] [-e <value>] [-g <value>]

ARGUMENTS
  NAME  Name of user.

FLAGS
  -d, --default_user        The default user is the user that is used when no token is provided. Use for public
                            applications where users should not be able to access data without a token.
  -e, --properties=<value>  New properties.
  -g, --group=<value>       New group.
  -h, --help                Show CLI help.
  -p, --password=<value>    New password for user.

DESCRIPTION
  Update user.

See code: src/commands/user/update.ts

• centia client add [NAME]
• centia client drop [ID]
• centia client get [ID]
• centia client update [ID]
• centia column add [SCHEMA] [TABLE] [COLUMN] [TYPE]
• centia column default [SCHEMA] [TABLE] [COLUMN] [DEFAULT]
• centia column drop [SCHEMA] [TABLE] [COLUMN]
• centia column get [SCHEMA] [TABLE] [COLUMN]
• centia column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE]
• centia column rename [SCHEMA] [TABLE] [COLUMN] [NAME]
• centia column type [SCHEMA] [TABLE] [COLUMN] [TYPE]
• centia constraint add [SCHEMA] [TABLE] [COLUMNS] [TYPE] [NAME]
• centia constraint drop [SCHEMA] [TABLE] [NAME]
• centia constraint get [SCHEMA] [TABLE] [NAME]
• centia help [COMMAND]
• centia import [PATH] [SCHEMA]
• centia index add [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME]
• centia index drop [SCHEMA] [TABLE] [NAME]
• centia index get [SCHEMA] [TABLE] [NAME]
• centia login
• centia logout
• centia privilege get [SCHEMA] [TABLE]
• centia privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGE]
• centia rule add
• centia rule drop [ID]
• centia rule get [ID]
• centia rule update [ID]
• centia schema add [SCHEMA]
• centia schema drop [SCHEMA]
• centia schema get [SCHEMA]
• centia schema rename [SCHEMA] [NAME]
• centia sql
• centia table add [SCHEMA] [TABLE]
• centia table drop [SCHEMA] [TABLE]
• centia table get [SCHEMA] [TABLE]
• centia table move [SCHEMA] [TABLE] [DESTINATION]
• centia table rename [SCHEMA] [TABLE] [NAME]
• centia user add [NAME]
• centia user drop [NAME]
• centia user get [ID]
• centia user update [NAME]

centia client add [NAME]

Create new client.

USAGE
  $ centia client add [NAME] [-n <value>] [-d <value>] [-r <value>] [-H <value>] [-p] [-c] [-h]

ARGUMENTS
  NAME  Name of new client.

FLAGS
  -H, --homepage=<value>      Homepage of the application.
  -c, --confirm               Client user must confirm the token exchange.
  -d, --description=<value>   Description of new client.
  -h, --help                  Show CLI help.
  -n, --name=<value>          Name of new client.
  -p, --public                Public client. No secret needed.
  -r, --redirect_uri=<value>  Redirect uri. Redirects will only be allowed to an uri in this list.

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]

List client(s).

USAGE
  $ centia client get [ID] [-h]

ARGUMENTS
  ID  Client id

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List client(s).

See code: src/commands/client/list.ts

centia client update [ID]

Update a client.

USAGE
  $ centia client update [ID] [-n <value>] [-d <value>] [-r <value>] [-p <value>] [-p] [-c] [-h]

ARGUMENTS
  ID  Id of client.

FLAGS
  -c, --confirm               Client user must confirm the token exchange.
  -d, --description=<value>   Description of new client.
  -h, --help                  Show CLI help.
  -n, --name=<value>          New name ofclient.
  -p, --homepage=<value>      Homepage of the application.
  -p, --public                Public client. No secret needed.
  -r, --redirect_uri=<value>  Redirect uri. Redirects will only be allowed to an uri in this list.

DESCRIPTION
  Update a client.

See code: src/commands/client/update.ts

centia column add [SCHEMA] [TABLE] [COLUMN] [TYPE]

Add a new column to a table.

USAGE
  $ centia column add [SCHEMA] [TABLE] [COLUMN] [TYPE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of new column.
  TYPE    Data type of new column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Add a new column to a table.

See code: src/commands/column/add.ts

centia column default [SCHEMA] [TABLE] [COLUMN] [DEFAULT]

Set default value for column. The default value is set when inserting a new row without a value for the column.

USAGE
  $ centia 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. The default value is set when inserting a new row without a value for the column.

See code: src/commands/column/default.ts

centia column drop [SCHEMA] [TABLE] [COLUMN]

Drop a column from table.

USAGE
  $ centia 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 from table.

See code: src/commands/column/drop.ts

centia column get [SCHEMA] [TABLE] [COLUMN]

List description of a column.

USAGE
  $ centia column get [SCHEMA] [TABLE] [COLUMN] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List description of a column.

See code: src/commands/column/list.ts

centia column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE]

Set nullable on column. If set the column can't be empty.

USAGE
  $ centia column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE] [-h]

ARGUMENTS
  SCHEMA    Name of schema.
  TABLE     Name of table.
  COLUMN    Name of column.
  NULLABLE  (true|false) Set column to nullable.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Set nullable on column. If set the column can't be empty.

See code: src/commands/column/nullable.ts

centia column rename [SCHEMA] [TABLE] [COLUMN] [NAME]

Rename a column.

USAGE
  $ centia 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 a column.

See code: src/commands/column/rename.ts

centia column type [SCHEMA] [TABLE] [COLUMN] [TYPE]

Set the data on column. It might be, the existing data type can't be transformed to the chosen one.

USAGE
  $ centia column type [SCHEMA] [TABLE] [COLUMN] [TYPE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of column.
  TYPE    New data type for column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Set the data on column. It might be, the existing data type can't be transformed to the chosen one.

See code: src/commands/column/type.ts

centia constraint add [SCHEMA] [TABLE] [COLUMNS] [TYPE] [NAME]

Add a constraint.

USAGE
  $ centia 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

centia constraint drop [SCHEMA] [TABLE] [NAME]

Drop a constraint.

USAGE
  $ centia constraint drop [SCHEMA] [TABLE] [NAME] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  NAME    Name of constraint.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Drop a constraint.

See code: src/commands/constraint/drop.ts

centia constraint get [SCHEMA] [TABLE] [NAME]

List constraint details.

USAGE
  $ centia constraint get [SCHEMA] [TABLE] [NAME] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  NAME    Name of constraint.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List constraint details.

See code: src/commands/constraint/list.ts

centia help [COMMAND]

Display help for centia.

USAGE
  $ centia help [COMMAND...] [-n]

ARGUMENTS
  COMMAND...  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] [SCHEMA]

Import files. Set path to a file or folder, which will be compressed, uploaded and imported into GC2.

USAGE
  $ centia import [PATH] [SCHEMA] [-s <value>] [-t <value>] [-T <value>] [-x <value>] [-y <value>] [-d] [-a]
    [-r] [-p] [-n <value>] [-h]

ARGUMENTS
  PATH    [default: .] Input path to file or folder.
  SCHEMA  Destination schema.

FLAGS
  -T, --timestamp=<value>         Name of timestamp field. Create a timestamp field in the import table. Omit argument
                                  for no timestamp field.
  -a, --append                    Append to existing table instead of creating new.
  -d, --dry_run                   Dry run. Only analyse files with no import.
  -h, --help                      Show CLI help.
  -n, --table_name=<value>        Name of table. Defaults to the name of the file. Can only be used when importing
                                  single file - not directories unless --append is used
  -p, --p_multi                   Promote single geometries to multi part.
  -r, --truncate                  Truncate table before appending. Only have effect if --append is set.
  -s, --s_srs=<value>             Fallback source SRS. Will be used if file doesn't contain projection information
  -t, --t_srs=<value>             Fallback target SRS. Will be used if no authority name/code is available. Defaults to
                                  EPSG:4326.
  -x, --x_possible_names=<value>  Specify the potential names of the columns that can contain X/longitude. Only effects
                                  CSV. Defaults to "lon*,Lon*,x,X"]
  -y, --y_possible_names=<value>  Specify the potential names of the columns that can contain Y/latitude. Only effects
                                  CSV. Defaults to "lat*,Lat*,y,Y"]

DESCRIPTION
  Import files. 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 [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME]

Add an new index to table.

USAGE
  $ centia index add [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME] [-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 new index.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Add an new index to table.

See code: src/commands/index/add.ts

centia index drop [SCHEMA] [TABLE] [NAME]

Drop an index from table.

USAGE
  $ centia 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
  Drop an index from table.

See code: src/commands/index/drop.ts

centia index get [SCHEMA] [TABLE] [NAME]

List index definition.

USAGE
  $ centia index get [SCHEMA] [TABLE] [NAME] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  NAME    Name of index.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List index definition.

See code: src/commands/index/list.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 logout

Logout the current user.

USAGE
  $ centia logout [-h]

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Logout the current user.

See code: src/commands/logout.ts

centia privilege get [SCHEMA] [TABLE]

List user privileges on table.

USAGE
  $ centia privilege get [SCHEMA] [TABLE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List user privileges on table.

See code: src/commands/privilege/list.ts

centia privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGE]

Set user privileges on table.

USAGE
  $ centia privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGE] [-h]

ARGUMENTS
  SCHEMA     Name of schema.
  TABLE      Name of table.
  USER       Name of user.
  PRIVILEGE  Which privilege.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Set user privileges on table.

See code: src/commands/privilege/set.ts

centia rule add

Create a 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 a 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]

List rule(s).

USAGE
  $ centia rule get [ID] [-h]

ARGUMENTS
  ID  Rule id

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List rule(s).

See code: src/commands/rule/list.ts

centia rule update [ID]

Update a 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 a rule.

See code: src/commands/rule/update.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 a schema.

USAGE
  $ centia schema drop [SCHEMA] [-h]

ARGUMENTS
  SCHEMA  Name of schema.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Drop a schema.

See code: src/commands/schema/drop.ts

centia schema get [SCHEMA]

List list of tables in schema.

USAGE
  $ centia schema get [SCHEMA] [-h]

ARGUMENTS
  SCHEMA  Name of schema.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List list of tables in schema.

See code: src/commands/schema/list.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 sql

Run SQL statements. If run without --statement inactive mode will be enabled.

USAGE
  $ centia sql [-s <value>] [-c <value>] [-f <value>] [-g wkt|geojson] [-p <value>] [-h]

FLAGS
  -c, --srs=<value>         [default: 4326] Output spatial reference system. Use EPSG codes.
  -f, --format=<value>      Output file format.
  -g, --geoformat=<option>  Output geometry in CSV and Excel.
                            <options: wkt|geojson>
  -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. Any select, insert, update and delete. No altering of schema is allowed.

DESCRIPTION
  Run SQL statements. If run without --statement inactive mode will be enabled.

See code: src/commands/sql.ts

centia table add [SCHEMA] [TABLE]

Create a new table.

USAGE
  $ centia 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

centia table drop [SCHEMA] [TABLE]

Drop a table.

USAGE
  $ centia table drop [SCHEMA] [TABLE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Drop a table.

See code: src/commands/table/drop.ts

centia table get [SCHEMA] [TABLE]

List table definition.

USAGE
  $ centia table get [SCHEMA] [TABLE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List table definition.

See code: src/commands/table/list.ts

centia table move [SCHEMA] [TABLE] [DESTINATION]

Move table to another schema.

USAGE
  $ centia 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

centia table rename [SCHEMA] [TABLE] [NAME]

Rename table.

USAGE
  $ centia 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

centia user add [NAME]

Create new user.

USAGE
  $ centia user add [NAME] [-h] [-p <value>] [-e <value>] [-P <value>] [-d]

ARGUMENTS
  NAME  Name of new user

FLAGS
  -P, --properties=<value>  Properties for new user
  -d, --default_user        The default user is the user that is used when no token is provided. Use for public
                            applications where users should not be able to access data without a token.
  -e, --email=<value>       E-mail for new user
  -h, --help                Show CLI help.
  -p, --password=<value>    password for 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 [ID]

List user(s).

USAGE
  $ centia user get [ID] [-h]

ARGUMENTS
  ID  User id

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List user(s).

See code: src/commands/user/list.ts

centia user update [NAME]

Update user.

USAGE
  $ centia user update [NAME] [-h] [-p <value>] [-d] [-e <value>] [-g <value>]

ARGUMENTS
  NAME  Name of user.

FLAGS
  -d, --default_user        The default user is the user that is used when no token is provided. Use for public
                            applications where users should not be able to access data without a token.
  -e, --properties=<value>  New properties.
  -g, --group=<value>       New group.
  -h, --help                Show CLI help.
  -p, --password=<value>    New password for user.

DESCRIPTION
  Update user.

See code: src/commands/user/update.ts

• 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 [HOST]
• 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 [COMMAND]
• gc2 import [PATH] [SCHEMA]
• gc2 index add [SCHEMA] [TABLE] [COLUMNS] [METHOD] [NAME]
• gc2 index drop [SCHEMA] [TABLE] [NAME]
• gc2 index get
• gc2 login
• gc2 logout
• gc2 privilege get [SCHEMA] [TABLE]
• gc2 privilege set [SCHEMA] [TABLE] [USER] [PRIVILEGE]
• 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 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>  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 of new client.
  -h, --help                  Show CLI help.
  -n, --name=<value>          Name of new client.
  -p, --homepage=<value>      Homepage of the application.
  -r, --redirect_uri=<value>  Redirect uri. Redirects will only be allowed to an uri in this list.

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]

List client(s).

USAGE
  $ gc2 client get [ID] [-h]

ARGUMENTS
  ID  Client id

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List client(s).

See code: src/commands/client/list.ts

gc2 client update [ID]

Update a client.

USAGE
  $ gc2 client update [ID] [-n <value>] [-d <value>] [-r <value>] [-p <value>] [-h]

ARGUMENTS
  ID  Id of client.

FLAGS
  -d, --description=<value>   Description of new client.
  -h, --help                  Show CLI help.
  -n, --name=<value>          New name ofclient.
  -p, --homepage=<value>      Homepage of the application.
  -r, --redirect_uri=<value>  Redirect uri. Redirects will only be allowed to an uri in this list.

DESCRIPTION
  Update a client.

See code: src/commands/client/update.ts

gc2 column add [SCHEMA] [TABLE] [COLUMN] [TYPE]

Add a new column to a table.

USAGE
  $ gc2 column add [SCHEMA] [TABLE] [COLUMN] [TYPE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of new column.
  TYPE    Data type of new column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Add a new column to a table.

See code: src/commands/column/add.ts

gc2 column default [SCHEMA] [TABLE] [COLUMN] [DEFAULT]

Set default value for column. The default value is set when inserting a new row without a value for the 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. The default value is set when inserting a new row without a value for the column.

See code: src/commands/column/default.ts

gc2 column drop [SCHEMA] [TABLE] [COLUMN]

Drop a column from table.

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 from table.

See code: src/commands/column/drop.ts

gc2 column get [SCHEMA] [TABLE] [COLUMN]

List description of a column.

USAGE
  $ gc2 column get [SCHEMA] [TABLE] [COLUMN] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  List description of a column.

See code: src/commands/column/list.ts

gc2 column nullable [SCHEMA] [TABLE] [COLUMN] [NULLABLE]

Set nullable on column. If set the column can't be empty.

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) Set column to nullable.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Set nullable on column. If set the column can't be empty.

See code: src/commands/column/nullable.ts

gc2 column rename [SCHEMA] [TABLE] [COLUMN] [NAME]

Rename a 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 a column.

See code: src/commands/column/rename.ts

gc2 column type [SCHEMA] [TABLE] [COLUMN] [TYPE]

Set the data on column. It might be, the existing data type can't be transformed to the chosen one.

USAGE
  $ gc2 column type [SCHEMA] [TABLE] [COLUMN] [TYPE] [-h]

ARGUMENTS
  SCHEMA  Name of schema.
  TABLE   Name of table.
  COLUMN  Name of column.
  TYPE    New data type for column.

FLAGS
  -h, --help  Show CLI help.

DESCRIPTION
  Set the data on column. It might be, the existing data type can't be transformed to the chosen one.

See code: src/commands/column/type.ts

gc2 connect [HOST]

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 [HOST] [-h] [-r]

ARGUMENTS
  HOST  Server host with scheme: http(s)

FLAGS
  -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 of constraint.

FLAGS