github.com/jackc/pgx/v5@v5.5.5/testsetup/postgresql_setup.sql (about)

     1  -- Create extensions and types.
     2  create extension hstore;
     3  create extension ltree;
     4  create domain uint64 as numeric(20,0);
     5  
     6  -- Create users for different types of connections and authentication.
     7  create user pgx_ssl with superuser PASSWORD 'secret';
     8  create user pgx_sslcert with superuser PASSWORD 'secret';
     9  set password_encryption = md5;
    10  create user pgx_md5 with superuser PASSWORD 'secret';
    11  set password_encryption = 'scram-sha-256';
    12  create user pgx_pw with superuser PASSWORD 'secret';
    13  create user pgx_scram with superuser PASSWORD 'secret';
    14  \set whoami `whoami`
    15  create user :whoami with superuser; -- unix domain socket user
    16  
    17  
    18  -- The tricky test user, below, has to actually exist so that it can be used in a test
    19  -- of aclitem formatting. It turns out aclitems cannot contain non-existing users/roles.
    20  create user " tricky, ' } "" \\ test user " superuser password 'secret';