jgpruitt

SQL Macros a.k.a. Dynamic SQL

Strings in Postgres

A little background on string literals that will be pertinent.

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS

select 'this is a string';

jgpruitt

Postgres Extensions from Scratch

Setup

Run postgres in a docker container and get a shell into it.

docker pull postgres
docker run -d --name ext-demo --hostname ext-demo -e POSTGRES_HOST_AUTH_METHOD=trust -p 127.0.0.1:5432:5432 postgres
docker exec ext-demo /bin/bash -c "apt-get update && apt-get install -y vim"