◐ Shell
clean mode source ↗

GitHub - passcod/adventofcode22: Advent of Code 2022

Skip to content

Navigation Menu

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Sign up

Appearance settings

Advent of Code 2022: PostgreSQL

First create a database and load the schema with

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.

Limitations

  • 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.