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'