GET databases/:database_name
Returns details about a specific database. The :database_name
is the value of the name field that the GET databases command returns.
Resource URL
https://<NODE>:5444/databases/:database_name
Authentication
Requires a VerticaAPIKey in the request header.
The API key must have restricted level security or higher.
Parameters
None.
Example Request
GET |
https://<NODE>:5444/databases/VMart |
Response:
{ "body": { "database_id": "VMart", "id": "VMart", "nodes": "v_vmart_node0001,v_vmart_node0002,v_vmart_node0003", "nodes_new": [ { "catalog_base": "/home/dbadmin", "data_base": "/home/dbadmin", "host": "10.20.100.247", "id": "v_vmart_node0001" }, { "catalog_base": "/home/dbadmin", "data_base": "/home/dbadmin", "host": "10.20.100.248", "id": "v_vmart_node0002" }, { "catalog_base": "/home/dbadmin", "data_base": "/home/dbadmin", "host": "10.20.100.249", "id": "v_vmart_node0003" } ], "path": "/home/dbadmin/VMart", "port": "5433", "restartpolicy": "ksafe", "status": "UP" }, "href": "/databases/VMart", "links": [ "/configuration", "/hosts", "/license", "/nodes", "/process", "/rebalance/process", "/status", "/Workload Analyzer/process" ], "mime-type": "application/vertica.database.json-v2" }