/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

53 votes271 views6 answers
Docker stop all containers
Shell/Bash
0 vote286 views1 answer
Dockerd failed to start daemon: failed to get temp dir to generate runtime scripts
Shell/Bash
1 vote260 views1 answer
Installing the virtualenv module
Shell/Bash
2 votes305 views1 answer
Dd usr1
Shell/Bash
2 votes281 views2 answers
Install magento extension composer
Shell/Bash
0 vote280 views1 answer
Git create branch without initial commit
Shell/Bash
49 votes257 views3 answers
Linux check if a port is open
Shell/Bash
1 vote266 views1 answer
Wsl cannot read realtime clock
Shell/Bash
2 votes281 views2 answers
Install blender on Debian Linux
Shell/Bash
1 vote286 views1 answer
Undefined reference to `sem_init'
Shell/Bash