Commodity Platform Database

Database code for Commodity Platform ingestion, and modelling data using PostgreSQL.

Launching psql on Windows

Powershell

chcp 65001 // UTF-8
$env:PGCLIENTENCODING = "UTF8"
psql -U postgres

Executing commands in psql

\c commodity
\i 'D:/path/to/file.sql'

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
migrations		migrations
schema/aer		schema/aer
README.md		README.md
commodity.sql		commodity.sql
timezone.sql		timezone.sql