From 1a97f6b9ee0c236d53eebdd0ccc72f8b24cf99ff Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Fri, 10 Aug 2018 15:58:03 -0700 Subject: flask and postgres notes --- software/postgres.page | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 software/postgres.page (limited to 'software/postgres.page') diff --git a/software/postgres.page b/software/postgres.page new file mode 100644 index 0000000..bdb01d8 --- /dev/null +++ b/software/postgres.page @@ -0,0 +1,17 @@ + +Start a quick local docker database: + + docker run -p 5432:5432 postgres:latest + +Connect (from outside): + + psql -h localhost -w postgres + +Dump current schema with something like: + + docker exec 6a018d9d8ef0 pg_dump -U postgres postgres -s | rg -v ^- > schema.sql + +Basic status from the psql command line: + + \l+ (list databases) + \dt+ (describe table) -- cgit v1.2.3