File: init.sql

package info (click to toggle)
usql 0.19.19-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 2,652 kB
  • sloc: sql: 1,115; sh: 643; ansic: 191; makefile: 60
file content (17 lines) | stat: -rw-r--r-- 469 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
\set POSTGRES_USER postgres
\set POSTGRES_PASS P4ssw0rd
\set POSTGRES_DB   postgres
\set POSTGRES_HOST `docker port postgres 5432 | head -n1`

\prompt NAME 'Create database user: '
\prompt -password PASS 'Password for "':NAME'": '

\connect 'postgres://':POSTGRES_USER':':POSTGRES_PASS'@':POSTGRES_HOST'/':POSTGRES_DB'?sslmode=disable'

DROP USER IF EXISTS :NAME;

CREATE USER :NAME PASSWORD :'PASS';

DROP DATABASE IF EXISTS :NAME;

CREATE DATABASE :NAME OWNER :NAME;