By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 12.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit |
SELECT 1
CREATE TABLE
INSERT 0 1
ALTER TABLE
| jsonb |
|---|
| [{"id": "11954_179415600_2441_333_1", "vehicle": {"trip": {"tripId": "1182456", "routeId": "2441_333", "startDate": "20200822", "startTime": "22:14:00", "scheduleRelationship": "SCHEDULED"}, "vehicle": {"id": "11954_179415600_2441_333_1"}, "position": {"speed": 0.0, "bearing": 297.0, "latitude": -33.876972, "longitude": 151.21237}, "timestamp": "1598100524", "congestionLevel": "RUNNING_SMOOTHLY", "occupancyStatus": "MANY_SEATS_AVAILABLE"}}] |
SELECT 1