PostgreSQL view output older than 90 days

Shell Programming and Scripting
1

I am trying to find the correct syntax to give me row output only older than 90 days. I am using psql NOT mySQL or MSSQL!

Here is the sql command i am running

SELECT 
  dataset.id,
  timezone('UTC', dataset.create_time)::date,
  history.name as History_Name,
  history.id,
  hda.name as File_Name,
  dataset.file_size
from
  dataset,
  history_dataset_association hda,
  history,
  job_to_output_dataset,
  job
where
  hda.dataset_id = dataset.id
  AND
  hda.history_id = history.id
  AND
  job_to_output_dataset.dataset_id = hda.id
  AND
  job.id = job_to_output_dataset.job_id
  AND
  job.tool_id like '%import%'
  AND
  dataset.file_size >   1073741824 
  AND
  dataset.purged = false
;

and this is my output file:

ID    timezone    history_name    id    file_name        size    
114601  2011-05-23    LID8661        5604    LID8661_FC61JL.txt.gz    8418255538
85750   2010-07-07    Unnamed history 4249    s_3_1_sequence.tmp    7992819712
85751   2010-07-07    Unnamed history 4249    s_3_2_sequence.tmp    7973703680
85748   2010-07-07    Unnamed history 4249    s_2_1_sequence        7670258636
85749   2010-07-07    Unnamed history 4249    s_2_2_sequence        7670258636
127814  2011-05-21     AC_testis_52-68 6311    s_6_sequence        7103900102
127868  2011-05-23    Unnamed history 6296    s_3_sequence        6680231672
128274  2011-05-26    5-26-11        6346    s_3_sequence         6680231672
83539   2010-06-13    AJ HD5-S        4472    s_6_1_sequence        5991875692
83540   2010-06-13    AJ HD5-S        4472    s_6_2_sequence        5991875692
98346   2010-09-24    dfmod24 Kc pA NT 5062   LID9058_FC61W.txt.gz    5864636496
83974   2010-06-17    Unnamed history 4486    LID8659_FC61W.txt.gz    5689413616
83988   2010-06-17    Unnamed history 4486    LID8660_FC61W.txt.gz    5612981394
98345   2010-09-24    dfmod23 S2 pA NT5061    LID9057_FC61WW7A.txt.gz    5430755938
126701  2011-05-11    293T_sigma.txt    6240    293T_R_sigma        5377059342
2

What is your unix/shell question?

3

I run psql with command options from #!/bin/sh

i actually figured it out

  AND
  dataset.create_time < (current_date - interval '3 months')

was added to the end of the file.