bschelst/ June 13, 2017/ Avamar/ 0 comments

[email protected]:~/>: 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’

Share this Post

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*

five + four =