admin@xxx:~/>: psql -p 5555 -U viewuser mcdb
mcdb=>
Example query:
SELECT * FROM “public”.”v_clients”;
SELECT v_clients.cid, v_clients.client_name, v_clients.client_addr,v_clients.os_type FROM “public”.”v_clients”;
select client_name,status_code,domain FROM v_activities_2 WHERE (status_code=30901 or status_code=30915) and recorded_date_time > current_timestamp – interval ’24 hours’
