'Load json file to database

I'm attempting to COPY json text file to postgres database. The json looks

{ 
"events": 
  [{                                                                                                   
     "timestamp": 1298734,                                                                                               
     "message": "START RequestId: bjn937645",                                                    
     "ingestiontime": 123456                                                                       
  }]
}

database columns are: ingestiontime, message, timestamp create table event_log (timestamp varchar, message varchar, ingestion_time varchar)

jsonpostgresqlcommand-line-interface


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions