/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 vote75 views2 answers
Force kill a process in mac terminal
Shell/Bash
4 votes106 views1 answer
Change user linuxcommand ch
Shell/Bash
0 vote125 views1 answer
Add user to dialout group
Shell/Bash
0 vote117 views1 answer
Asking git token in ubuntu again n again
Shell/Bash
3 votes141 views3 answers
Git reset keep changes
Shell/Bash
49 votes121 views6 answers
Seed specific seeder laravel
Shell/Bash
0 vote115 views1 answer
Change git console text size
Shell/Bash
1 vote109 views2 answers
Install kazam ubuntu 18.04
Shell/Bash
0 vote115 views1 answer
Git checkout multiple branches at once
Shell/Bash
27 votes112 views3 answers
Extract a tar.xz file linux
Shell/Bash