\dj [ PATTERN ]
The \dj [ PATTERN ]
meta-command returns all projections showing the schema, projection name, owner, and node. The returned rows include superprojections, live aggregate projections, Top-K projections, and projections with expressions:
vmartdb=> \dj
List of projections
Schema | Name | Owner | Node
--------------+--------------------------------+---------+--------------------
public | product_dimension_node0001 | dbadmin | v_wmartdb_node0001
public | product_dimension_node0002 | dbadmin | v_wmartdb_node0002
public | product_dimension_node0003 | dbadmin | v_wmartdb_node0003
online_sales | call_center_dimension_node0001 | dbadmin | v_wmartdb_node0001
online_sales | call_center_dimension_node0002 | dbadmin | v_wmartdb_node0002
online_sales | call_center_dimension_node0003 | dbadmin | v_wmartdb_node0003
...
If you supply a projection name as an argument, the system returns fewer records:
vmartdb=> \dj call_center_dimension_n*
List of projections
Schema | Name | Owner | Node
--------------+--------------------------------+---------+--------------------
online_sales | call_center_dimension_node0001 | dbadmin | v_wmartdb_node0001
online_sales | call_center_dimension_node0002 | dbadmin | v_wmartdb_node0002
online_sales | call_center_dimension_node0003 | dbadmin | v_wmartdb_node0003
(3 rows)