Xianlin

How to know the number of records for the past 3 months for the database table "auditrecorddata" in EJBCA CA database? caejbca=# \d+ auditrecorddata; Table "public.auditrecorddata" Column | Type | Modifiers | Storage | Stats target | Description -------------------+---------+-----------+----------+--------------+------------- pk | text | not null | extended | | additionaldetails | text | | extended | | authtoken | text | not null | extended | | customid | text | | extended | | eventstatus | text...

Moved to Help Forums...

Hi Primekey I want to know how many records has been created into the below table "auditrecorddata" for the past 3 months. Would you please give me some advice or help on the query command line? Thanks. caejbca=# \d+ auditrecorddata; Table "public.auditrecorddata" Column | Type | Modifiers | Storage | Stats target | Description -------------------+---------+-----------+----------+--------------+------------- pk | text | not null | extended | | additionaldetails | text | | extended | | authtoken |...