/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

36 votes264 views6 answers
Restart nginx ubuntu
Shell/Bash
0 vote193 views1 answer
Switch to a different remote branch git
Shell/Bash
0 vote217 views1 answer
Git tag finalize app
Shell/Bash
63 votes212 views2 answers
How to remove remote origin from git repo
Shell/Bash
0 vote216 views1 answer
Install modules mu
Shell/Bash
10 votes200 views2 answers
Search for filename recursively linux
Shell/Bash
4 votes209 views1 answer
ERROR: Could not install packages due to an EnvironmentError: [WinError 5] Access is denied: 'd:\\anaconda3\\scripts\\pip.exe' Consider using the `--user` option or check the permissions.
Shell/Bash
0 vote198 views1 answer
Restart mosquitto
Shell/Bash
0 vote187 views1 answer
Epson l220 ubuntu driver
Shell/Bash
0 vote195 views2 answers
Grep domain
Shell/Bash