/Shell/Bash/Connecting to timescaledb from terminal

Connecting to timescaledb from terminal

sudo su -l postgres
psql

Connecting to timescaledb from terminal

CREATE database test_db;

#change into the test_db:
\c test_db

Output:
You are now connected to database "test_db" as user "postgres".

#create TimescaleDB extension:
CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;

Similar codes

1 vote130 views2 answers
Chrome update ubuntu 20.04
Shell/Bash
0 vote135 views1 answer
Failed to build logging Installing collected packages: logging Running setup.py install for logging ... error
Shell/Bash
0 vote121 views1 answer
Win kex kali linux
Shell/Bash
2 votes103 views1 answer
Git pull master for feature branch
Shell/Bash
0 vote107 views1 answer
Ssh-copy-id specific file
Shell/Bash
0 vote106 views2 answers
Uninstall kubeadm
Shell/Bash
0 vote109 views1 answer
Ssh allow password login subnet
Shell/Bash
0 vote116 views5 answers
Shell Script to Install Ansible AWX on centos 7
Shell/Bash
1 vote110 views1 answer
Why i am not able to make a directory in htdocs folder in ubuntu
Shell/Bash
1 vote124 views1 answer
How to get powers
Shell/Bash