DATABASE_CONNECTIONS
Lists the connections to other databases for importing and exporting data. See Importing and Exporting Data Across Databases in the Administrator's Guide.
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 |
Example
=> 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)