Termux Postgresql Introduction

title: "Termux Postgresql Introduction"
date: 2021-02-13T23:29:10+08:00
draft: true
tags: ['termux','postgresql']
author: "dadigang"
author_cn: "大地缸"
personal: "http://www.real007.cn"

关于作者

http://www.real007.cn/about

Create skeleton database

mkdir -p $PREFIX/var/lib/postgresql
initdb $PREFIX/var/lib/postgresql

Starting the database

pg_ctl -D $PREFIX/var/lib/postgresql start

Similarly stop the database using

pg_ctl -D $PREFIX/var/lib/postgresql stop

Create User

$ createuser --superuser --pwprompt yourUserName

Create your database:

$ createdb mydb

Open your database

$ psql mydb

You will now see the promt

mydb=#