summaryrefslogtreecommitdiff
path: root/priv/templates/sample_psql.eex
diff options
context:
space:
mode:
Diffstat (limited to 'priv/templates/sample_psql.eex')
-rw-r--r--priv/templates/sample_psql.eex7
1 files changed, 7 insertions, 0 deletions
diff --git a/priv/templates/sample_psql.eex b/priv/templates/sample_psql.eex
new file mode 100644
index 000000000..f0ac05e57
--- /dev/null
+++ b/priv/templates/sample_psql.eex
@@ -0,0 +1,7 @@
+CREATE USER <%= dbuser %> WITH ENCRYPTED PASSWORD '<%= dbpass %>';
+CREATE DATABASE <%= dbname %> OWNER <%= dbuser %>;
+\c <%= dbname %>;
+--Extensions made by ecto.migrate that need superuser access
+CREATE EXTENSION IF NOT EXISTS citext;
+CREATE EXTENSION IF NOT EXISTS pg_trgm;
+CREATE EXTENSION IF NOT EXISTS "uuid-ossp";