Version: 13.0-dev-33
Build #: 30330
Build Date: 2012-Nov-27 09:23:25 AM

Add support for "Detail View" in Vertica for more schema objects whose information is available in system tables

A.) No details view for Databases in Vertica

We can query the catalog table using select * from v_catalog.databases
--

B.) No details view for Procedures
select * from v_catalog.user_procedures gives procedure_name, procedure_arguments, schema_name

--

C.) No details view for Schemas.
We do extract and script schemas in Vertica and we can extend the detail view for schema as well
--

D.) No detail view for profiles under Security node
We can query catalog table profiles using the query select * from v_catalog.profiles