Hi,
it seems not work...
bash-4.2$ psql
psql (10.6)
Type "help" for help.
postgres=# SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM vm_images_view
where imagestatus = 2);
ERROR: relation "vms" does not exist
LINE 1: SELECT vm_name from vms where vm_guid = (SELECT vm_guid FROM...
^
postgres=#
Thanks a lot anyway.
M.