Greenplum/Postgres DB: databases API

Get a specific database

GET /api/databases/:id

Parameters

Name	Description
id	The id of a database

Request

Headers

Host: example.org
Cookie: _session_id=QnExazBYVWlyTnlST3JGU0kxYW5xV0lWSytmRzJsT1JFa1Ntbk0vK2UxVXJpc29ERG1nTUlIa0NKbmgvYUVndWRUT21hYXJzWVBxa0Z0NWNxK3Q5VlZvREJSS0k5c0FPWDZDMUhRUmtQZVlWeVJERkVtWk1yY0xPdXplZllCenJyL2dtUUVqSnpkb1FJUnVYTDIzSmxTSFBrL3hEQzNkNTJlRnhoakFUd1BzV2lrbGcyVVhNVXRKK2FselBOL21QdWJtakFxWWRRYUFUZWF1MGNaTmFRS1lzRmh5OEMxQU1ka2l5VkZXWU1Qc1VodDJRbjV1bEJOQmlqNFBzYS9Fbnh5dE4ya2dNY0ZwOFpxZG1UeDB3LzlQaWlKRmNlS0RLZDFTeGNQZFRCWm1XWTNCZEs1QzBudWFuUjl5TFlXeFB3SEY2Qll6ZTl0TEx4UEFzTnJlaGM3TEtDbUF4Z3JLbFczN1ZhMkhQb2V1NzBneXZYM0JsVXZXeWV1V0NWV2F6WkR6K0RNWWdiNjZBczdtd2Y0SnkyYjVyaGkyUGN3MnU0VDE3TjlXZmFPST0tLXFPazdYQ3RIQUFqbnJ5R2pXMzFzbVE9PQ%3D%3D--3f61594cfc718203aab5e9d80b5684a33d0579f0

Route

GET /api/databases/1000001

Response

Headers

X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
X-Content-Type-Options: nosniff
Content-Type: application/json; charset=utf-8
ETag: W/"6fea68bdc653a5cca0d827beb7871bfd"
Cache-Control: max-age=0, private, must-revalidate
Set-Cookie: _session_id=MEdmSlUyRUlIK3dLV05IeWJ4cFovMGNoajVEcjBBRjlKd1hObWJReDNHSURkMkVPbVBiRGR0V0libTZXcUZYWWU4UnVRSi9iS0EzdmRCUHRSbDlBOGtzanBDc1NmUC93ODBtdlRDeXh2cGRoY0ZuQzFLOENZTFN5bktEWGNnMVpOQ0N3MDlNb1VSQkFtZ24wVlBNRDd6M0VyWW91NnhJMnNJejVVdXQvaGcwVGw5ZUxXRTR1ak5FM2tGMmFJWVZaeDRZeGVGSkt6L0JPWTVHR3M4a245a2h6YWpRbWFhSzJ3bXFMSGVleVJYNjg4VGZ2cUN4RGwzdzdPcDZ6MEZZV0Q5Rk9RN0pzY1J4SUVtamExMnBUL2xKYnhzeC9scGcrb3dUK1p1Sm0zVlBPVW9laG9jeE9OQkJrN3ZVSllKcUVXSGlwMnJhSGtZeWVQT0U3UzByQVpxeXg4NkVpczBjTG5HeUN3RkpJY002bDNYWVhFcFRySFgwK0tKWVBETkVzVE8vMTlRWHIxdVJGblVSZW44YVRlSDZ4Ty9MTzFTL2EvNTV2TCsydndEeUVYMXJMMllHQ2VXbFgzUElkTStlLy0tZlBaWW81WnhsNFFnVGtTTkkrVGM4Zz09--92074ef6364d41c2ef617df5b4f1870d99f05086; path=/; HttpOnly
X-Request-Id: 7e7d0872-20d7-46bc-971a-8b67923f9cea
X-Runtime: 0.034382
Content-Length: 1277

Status

200 OK

Body

{"response":{"id":1000001,"name":"default","data_source":{"id":1000002,"name":"Owners","entity_type":"gpdb_data_source","is_deleted":false,"shared":false,"owner_id":1000006,"version":"9.1.2 - FactoryVersion","is_hawq":null,"state":"online","public":false,"host":"data_source.emc.com","port":5000,"ssl":false,"online":true,"db_name":"postgres","description":null,"db_username":"username","owner":{"id":1000006,"username":"owner","first_name":"searchquery","last_name":"User_1","image":{"original":"/paperclip/users/images/001/000/006/original/User.png?1554329366","icon":"/paperclip/users/images/001/000/006/icon/User.png?1554329366","entity_type":"image","complete_json":true},"is_deleted":null,"auth_method":"internal","ldap_group_id":null,"user_type":"analytics_developer","entity_type":"user","using_default_image":false,"active_license":true,"is_siteadmin":false,"roles":["data_admin"],"email":"chorususer282295@alpinenow.com","title":"Chief Data Scientist","dept":"Corporation Corp., Inc.","notes":"One of our top performers","admin":false,"subscribed_to_emails":true,"tags":[],"deactivated_at":null,"complete_json":true},"tags":[],"schema_blacklist":[],"data_source_provider":"Greenplum Database","complete_json":true},"entity_type":"gpdb_database","complete_json":true}}