/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

25 votes140 views6 answers
Error: failed to push some refs to
Shell/Bash
1 vote129 views1 answer
Remove space at end of each line file
Shell/Bash
1 vote141 views1 answer
How to export a GPG public key to a file
Shell/Bash
10 votes175 views2 answers
How to uninstall composer in ubuntu
Shell/Bash
0 vote147 views1 answer
Pull Ubuntu image
Shell/Bash
1 vote207 views1 answer
Error: failed to synchronize all databases (invalid or corrupted database (PGP signature))
Shell/Bash
5 votes154 views4 answers
Reload .bashrc
Shell/Bash
0 vote138 views1 answer
Sed insert multiple lines after match
Shell/Bash
0 vote136 views1 answer
List all ssh connections ubuntu
Shell/Bash
1 vote135 views2 answers
Powershell rename replace
Shell/Bash