-- Earn every builtin achievement with a single role, including the meta -- achievements. Repetitive events are generated with \gexec. CREATE ROLE t_all SUPERUSER LOGIN; \c - t_all NOTICE: [BRONZE] Achievement unlocked: Welcome (+10) DETAIL: Connect to the server for the first time. Total score: 10. \set QUIET on \o /dev/null -- bronze SELECT 1; NOTICE: [BRONZE] Achievement unlocked: Hello, World (+10) DETAIL: Run your first SELECT. Total score: 20. CREATE TABLE a_t (id int, j jsonb); NOTICE: [BRONZE] Achievement unlocked: First Table (+10) DETAIL: Create your first table. Total score: 30. CREATE INDEX ON a_t (id); NOTICE: [BRONZE] Achievement unlocked: Indexer (+10) DETAIL: Create your first index. Total score: 40. CREATE FUNCTION a_f() RETURNS int LANGUAGE sql AS 'SELECT 1'; NOTICE: [BRONZE] Achievement unlocked: Functionary (+10) DETAIL: Create your first function or procedure. Total score: 50. WITH x AS (SELECT 1) SELECT * FROM x; NOTICE: [BRONZE] Achievement unlocked: WITH Love (+10) DETAIL: Run a query with a common table expression. Total score: 60. SELECT 1 FROM a_t JOIN a_t b USING (id); NOTICE: [BRONZE] Achievement unlocked: All Connected (+10) DETAIL: Run a query with an explicit JOIN. Total score: 70. EXPLAIN SELECT 1; NOTICE: [BRONZE] Achievement unlocked: Investigator (+10) DETAIL: Ask the planner with EXPLAIN. Total score: 80. SET pg_achievements.notify = off; -- see 04_errors SELECT 'SELEC ' || g FROM generate_series(1, 10) g \gexec SELEC 1 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 1 ^ SELEC 2 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 2 ^ SELEC 3 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 3 ^ SELEC 4 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 4 ^ SELEC 5 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 5 ^ SELEC 6 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 6 ^ SELEC 7 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 7 ^ SELEC 8 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 8 ^ SELEC 9 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 9 ^ SELEC 10 ERROR: syntax error at or near "SELEC" LINE 1: SELEC 10 ^ RESET pg_achievements.notify; SELECT 'SELECT * FROM a_t' FROM generate_series(1, 1000) \gexec SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t NOTICE: [BRONZE] Achievement unlocked: Stargazer (+10) DETAIL: Run 100 queries with SELECT *. Total score: 100. SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t NOTICE: [SILVER] Achievement unlocked: A Thousand and One Queries (+25) DETAIL: Run 1001 SELECT statements. Total score: 125. SELECT * FROM a_t SELECT * FROM a_t SELECT * FROM a_t NOTICE: [SILVER] Achievement unlocked: Star Veteran (+25) DETAIL: Run 1000 queries with SELECT *. Total score: 150. SELECT * FROM a_t SET pg_achievements.test_now = '2026-11-18 04:00:00-08'; SELECT 'SELECT 1' FROM generate_series(1, 20) \gexec NOTICE: [BRONZE] Achievement unlocked: Night Owl (+10) DETAIL: Run a query between 03:00 and 05:00. Total score: 160. SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 SELECT 1 NOTICE: [SILVER] Achievement unlocked: Night Shift (+25) DETAIL: Run 20 queries between 03:00 and 05:00. Total score: 185. SELECT 1 RESET pg_achievements.test_now; SELECT 1 FROM a_t WHERE id = NULL; NOTICE: [BRONZE] Achievement unlocked: NULL Is Not Equal to NULL (+10) DETAIL: Compare with = NULL instead of IS NULL. Total score: 195. NOTICE: [SILVER] Achievement unlocked: Collector (+25) DETAIL: Collect every bronze achievement. Total score: 220. -- silver EXPLAIN ANALYZE SELECT 1; NOTICE: [SILVER] Achievement unlocked: Detective (+25) DETAIL: Run EXPLAIN ANALYZE. Total score: 245. WITH RECURSIVE r AS (SELECT 1 UNION SELECT 1 FROM r) SELECT * FROM r; NOTICE: [SILVER] Achievement unlocked: Recursion: See Recursion (+25) DETAIL: Run a WITH RECURSIVE query. Total score: 270. SELECT row_number() OVER () FROM a_t; NOTICE: [SILVER] Achievement unlocked: Open Window (+25) DETAIL: Use a window function. Total score: 295. SELECT * FROM a_t, LATERAL (SELECT a_t.id) s; NOTICE: [SILVER] Achievement unlocked: Lateral Thinking (+25) DETAIL: Use LATERAL. Total score: 320. SELECT j -> 'a', j -> 'b', j ->> 'c', j ->> 'd', j @> '{}', j ? 'e', j -> 'f', j -> 'g', j -> 'h', j -> 'i' FROM a_t; NOTICE: [SILVER] Achievement unlocked: JSONB Juggler (+25) DETAIL: Use the JSONB operators ->, ->>, @> or ? 10 times. Total score: 345. SET pg_achievements.test_time_shift = 3601; SELECT 1; NOTICE: [SILVER] Achievement unlocked: Patient (+25) DETAIL: Wait for a query that runs longer than a minute. Total score: 370. NOTICE: [PLATINUM] Achievement unlocked: Marathon (+100) DETAIL: Wait for a query that runs longer than an hour. Total score: 470. BEGIN; ROLLBACK; NOTICE: [PLATINUM] Achievement unlocked: Time Machine (+100) DETAIL: Roll back a transaction that ran for over an hour. Total score: 570. RESET pg_achievements.test_time_shift; CREATE INDEX CONCURRENTLY ON a_t (j); NOTICE: [SILVER] Achievement unlocked: No Locks (+25) DETAIL: Create an index CONCURRENTLY. Total score: 595. CREATE FUNCTION a_trg() RETURNS trigger LANGUAGE plpgsql AS 'BEGIN RETURN NEW; END'; CREATE TRIGGER a_trg BEFORE INSERT ON a_t FOR EACH ROW EXECUTE FUNCTION a_trg(); NOTICE: [SILVER] Achievement unlocked: Trigger Happy (+25) DETAIL: Create a trigger. Total score: 620. CREATE TABLE a_p (id int) PARTITION BY LIST (id); NOTICE: [SILVER] Achievement unlocked: Divide and Conquer (+25) DETAIL: Create a partitioned table or a partition. Total score: 645. CREATE EXTENSION pg_stat_statements; DROP EXTENSION pg_stat_statements; CREATE EXTENSION pg_stat_statements; DROP EXTENSION pg_stat_statements; CREATE EXTENSION pg_stat_statements; NOTICE: [SILVER] Achievement unlocked: Expanding Horizons (+25) DETAIL: Create 3 extensions. Total score: 670. DROP EXTENSION pg_stat_statements; -- gold UPDATE a_t SET id = id; NOTICE: [GOLD] Achievement unlocked: Forgot WHERE (+50) DETAIL: UPDATE without a WHERE clause. Total score: 720. DELETE FROM a_t; NOTICE: [GOLD] Achievement unlocked: Forgot WHERE, Part 2 (+50) DETAIL: DELETE without a WHERE clause. Total score: 770. SET pg_achievements.notify = off; SELECT 'DO $$ BEGIN RAISE EXCEPTION ''x'' USING ERRCODE = ''40P01''; END $$' FROM generate_series(1, 5) \gexec DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40P01'; END $$ ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE DO $$ BEGIN RAISE EXCEPTION 'x' USING ERRCODE = '40001'; END $$; ERROR: x CONTEXT: PL/pgSQL function inline_code_block line 1 at RAISE RESET pg_achievements.notify; SET pg_achievements.test_now = '2026-11-20 20:00:00-08'; CREATE TABLE a_friday (id int); NOTICE: [GOLD] Achievement unlocked: Friday Deploy (+50) DETAIL: Run DDL on a Friday after 18:00. Total score: 970. RESET pg_achievements.test_now; CREATE TABLE a_big AS SELECT generate_series(1, 2000) AS id; ANALYZE a_big; SELECT count(*) FROM a_big; NOTICE: [GOLD] Achievement unlocked: Indexes Are for the Weak (+50) DETAIL: Scan a table of a million rows sequentially. Total score: 1020. SELECT pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1), pg_terminate_backend(-1) FROM generate_series(1, 0); NOTICE: [GOLD] Achievement unlocked: Executioner (+50) DETAIL: Call pg_terminate_backend. Total score: 1070. NOTICE: [PLATINUM] Achievement unlocked: Serial Executioner (+100) DETAIL: Call pg_terminate_backend 10 times. Total score: 1170. TRUNCATE a_t; NOTICE: [GOLD] Achievement unlocked: Clean Slate (+50) DETAIL: TRUNCATE a table. Total score: 1220. VACUUM FULL a_t; NOTICE: [GOLD] Achievement unlocked: Master of the Table (+50) DETAIL: Run VACUUM FULL. Total score: 1270. SELECT 1 FROM a_t t0 JOIN a_t t1 USING (id) JOIN a_t t2 USING (id) JOIN a_t t3 USING (id) JOIN a_t t4 USING (id) JOIN a_t t5 USING (id) JOIN a_t t6 USING (id) JOIN a_t t7 USING (id) JOIN a_t t8 USING (id) JOIN a_t t9 USING (id) JOIN a_t t10 USING (id); NOTICE: [GOLD] Achievement unlocked: JOINs Without Borders (+50) DETAIL: Run a query with 8 JOINs. Total score: 1320. NOTICE: [PLATINUM] Achievement unlocked: Ten JOINs (+100) DETAIL: Run a query with 10 JOINs. Total score: 1420. SELECT format('CREATE TABLE a_many_%s ()', g) FROM generate_series(1, 100) g \gexec CREATE TABLE a_many_1 () CREATE TABLE a_many_2 () CREATE TABLE a_many_3 () CREATE TABLE a_many_4 () CREATE TABLE a_many_5 () CREATE TABLE a_many_6 () CREATE TABLE a_many_7 () CREATE TABLE a_many_8 () CREATE TABLE a_many_9 () CREATE TABLE a_many_10 () CREATE TABLE a_many_11 () CREATE TABLE a_many_12 () CREATE TABLE a_many_13 () CREATE TABLE a_many_14 () CREATE TABLE a_many_15 () CREATE TABLE a_many_16 () CREATE TABLE a_many_17 () CREATE TABLE a_many_18 () CREATE TABLE a_many_19 () CREATE TABLE a_many_20 () CREATE TABLE a_many_21 () CREATE TABLE a_many_22 () CREATE TABLE a_many_23 () CREATE TABLE a_many_24 () CREATE TABLE a_many_25 () CREATE TABLE a_many_26 () CREATE TABLE a_many_27 () CREATE TABLE a_many_28 () CREATE TABLE a_many_29 () CREATE TABLE a_many_30 () CREATE TABLE a_many_31 () CREATE TABLE a_many_32 () CREATE TABLE a_many_33 () CREATE TABLE a_many_34 () CREATE TABLE a_many_35 () CREATE TABLE a_many_36 () CREATE TABLE a_many_37 () CREATE TABLE a_many_38 () CREATE TABLE a_many_39 () CREATE TABLE a_many_40 () CREATE TABLE a_many_41 () CREATE TABLE a_many_42 () CREATE TABLE a_many_43 () CREATE TABLE a_many_44 () CREATE TABLE a_many_45 () CREATE TABLE a_many_46 () CREATE TABLE a_many_47 () CREATE TABLE a_many_48 () CREATE TABLE a_many_49 () CREATE TABLE a_many_50 () CREATE TABLE a_many_51 () CREATE TABLE a_many_52 () CREATE TABLE a_many_53 () CREATE TABLE a_many_54 () CREATE TABLE a_many_55 () CREATE TABLE a_many_56 () CREATE TABLE a_many_57 () CREATE TABLE a_many_58 () CREATE TABLE a_many_59 () CREATE TABLE a_many_60 () CREATE TABLE a_many_61 () CREATE TABLE a_many_62 () CREATE TABLE a_many_63 () CREATE TABLE a_many_64 () CREATE TABLE a_many_65 () CREATE TABLE a_many_66 () CREATE TABLE a_many_67 () CREATE TABLE a_many_68 () CREATE TABLE a_many_69 () CREATE TABLE a_many_70 () CREATE TABLE a_many_71 () CREATE TABLE a_many_72 () CREATE TABLE a_many_73 () CREATE TABLE a_many_74 () CREATE TABLE a_many_75 () CREATE TABLE a_many_76 () CREATE TABLE a_many_77 () CREATE TABLE a_many_78 () CREATE TABLE a_many_79 () CREATE TABLE a_many_80 () CREATE TABLE a_many_81 () CREATE TABLE a_many_82 () CREATE TABLE a_many_83 () CREATE TABLE a_many_84 () CREATE TABLE a_many_85 () CREATE TABLE a_many_86 () CREATE TABLE a_many_87 () CREATE TABLE a_many_88 () CREATE TABLE a_many_89 () CREATE TABLE a_many_90 () CREATE TABLE a_many_91 () CREATE TABLE a_many_92 () CREATE TABLE a_many_93 () CREATE TABLE a_many_94 () CREATE TABLE a_many_95 () CREATE TABLE a_many_96 () NOTICE: [GOLD] Achievement unlocked: Table Collector (+50) DETAIL: Create 100 tables. Total score: 1470. NOTICE: [PLATINUM] Achievement unlocked: Gold Rush (+100) DETAIL: Collect every gold achievement. Total score: 1570. CREATE TABLE a_many_97 () CREATE TABLE a_many_98 () CREATE TABLE a_many_99 () CREATE TABLE a_many_100 () -- platinum CREATE DATABASE a_db; DROP DATABASE a_db; NOTICE: [PLATINUM] Achievement unlocked: You Only Live Once (+100) DETAIL: Drop a database. Total score: 1670. SELECT 'DROP TABLE ' || string_agg(format('a_many_%s', g), ', ') FROM generate_series(1, 50) g \gexec DROP TABLE a_many_1, a_many_2, a_many_3, a_many_4, a_many_5, a_many_6, a_many_7, a_many_8, a_many_9, a_many_10, a_many_11, a_many_12, a_many_13, a_many_14, a_many_15, a_many_16, a_many_17, a_many_18, a_many_19, a_many_20, a_many_21, a_many_22, a_many_23, a_many_24, a_many_25, a_many_26, a_many_27, a_many_28, a_many_29, a_many_30, a_many_31, a_many_32, a_many_33, a_many_34, a_many_35, a_many_36, a_many_37, a_many_38, a_many_39, a_many_40, a_many_41, a_many_42, a_many_43, a_many_44, a_many_45, a_many_46, a_many_47, a_many_48, a_many_49, a_many_50 NOTICE: [PLATINUM] Achievement unlocked: Scorched Earth (+100) DETAIL: Drop 50 tables. Total score: 1770. NOTICE: [PLATINUM] Achievement unlocked: Platinum Collection (+100) DETAIL: Collect every other achievement. Total score: 1870. \o \set QUIET off SELECT achievements.sync(); sync ------ t (1 row) SELECT count(*) AS unlocked, sum(points) AS score FROM achievements.my; unlocked | score ----------+------- 46 | 1870 (1 row) SELECT code FROM achievements.progress WHERE NOT unlocked; code ------ (0 rows)