tablesPG ​
Command:
tablesPG
Category: Object Inspection
Status: Production Ready
Description ​
Get a list of all tables from PostgreSQL
Syntax ​
bash
hana-cli tablesPG [schema] [table] [options]Aliases ​
tablespgtablespostgrestablesPostgrestables-postgrestables-postgressqltablesPOSTGRES
Command Diagram ​
Parameters ​
Positional Arguments ​
| Parameter | Type | Description |
|---|---|---|
schema | string | Schema name filter (optional positional input). |
table | string | Table name filter (optional positional input). |
Options ​
| Option | Alias | Type | Default | Description |
|---|---|---|---|---|
--table | -t | string | * | PostgreSQL table name pattern to match. |
--schema | -s | string | **CURRENT_SCHEMA** | Schema name or pattern to match. |
--profile | -p | string | pg | Profile used to route execution to PostgreSQL mode. |
--limit | -l | number | 200 | Maximum number of rows returned. |
For additional shared options from the common command builder, use hana-cli tablesPG --help.
Examples ​
Basic Usage ​
bash
hana-cli tablesPG --table * --schema MYSCHEMAList PostgreSQL tables matching schema and table filters.