\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)