aboutsummaryrefslogtreecommitdiffstats
path: root/db/postgres
diff options
context:
space:
mode:
authorterminaldweller <thabogre@gmail.com>2022-06-10 10:56:17 +0000
committerterminaldweller <thabogre@gmail.com>2022-06-10 10:56:17 +0000
commita8c27881f7e6fe7b4cd4d0f6396a4d8c5d43008c (patch)
tree9c3476400c7b8099dcc42f52e124c864d6d09282 /db/postgres
parentcleaned up colo (diff)
downloadscripts-a8c27881f7e6fe7b4cd4d0f6396a4d8c5d43008c.tar.gz
scripts-a8c27881f7e6fe7b4cd4d0f6396a4d8c5d43008c.zip
updates
Diffstat (limited to 'db/postgres')
-rw-r--r--db/postgres/create_db.pgsql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/postgres/create_db.pgsql b/db/postgres/create_db.pgsql
new file mode 100644
index 0000000..3c52221
--- /dev/null
+++ b/db/postgres/create_db.pgsql
@@ -0,0 +1,2 @@
+SELECT 'CREATE DATABASE irc'
+WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'irc')\gexec