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)