Thanks zenofmud. Here's what I've got so far. I've tried playing around with the outputs and still not getting data entry into the postgres fields. I've attached the screenshots for the complete message. The "mydb" node allows you to craft the sql inside the node, vs having to pass it to the node. I'm thinking that there might be an issue with calling object variables inside that node....but i don't know enough to confirm that.
Thanks thebaldgeek, just saw your edits...adsb exchange has a binary field for mil, 1 is mil 0 is not. The json I get is when I query asb_exchange 
