First create a database and load the schema with
psql < schema.sql
Then each day is self-contained and written in PSQL:
cd day01
psql < program.sql
The input is placed in input.txt
alongside the program.
- PSQL syntax and macros are allowed
- PostgreSQL version is 14.5
- User running the code is a postgres superuser
- Extensions, PLPgSQL, others languages, etc are allowed but solutions should primarily be in SQL where possible.