DATABASE_CONNECTIONS
Lists the connections to other databases for importing and exporting data.
Lists the connections to other databases for importing and exporting data. See Moving Data Between Vertica Databases.
| Column Name | Data Type | Description |
|---|---|---|
DATABASE |
VARCHAR | The name of the connected database |
USERNAME |
VARCHAR | The username used to create the connection |
HOST |
VARCHAR | The host name used to create the connection |
PORT |
VARCHAR | The port number used to create the connection |
ISVALID |
BOOLEAN | Whether the connection is still open and usable or not |
Examples
=> CONNECT TO VERTICA vmart USER dbadmin PASSWORD '' ON '10.10.20.150',5433;
CONNECT
=> SELECT * FROM DATABASE_CONNECTIONS;
database | username | host | port | isvalid
----------+----------+--------------+------+---------
vmart | dbadmin | 10.10.20.150 | 5433 | t
(1 row)