/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

20 votes330 views4 answers
Increment variable bash
Shell/Bash
0 vote312 views1 answer
Download all branched on git clone
Shell/Bash
6 votes310 views1 answer
Pm2 install ubuntu
Shell/Bash
1 vote317 views1 answer
Powershell grab regex
Shell/Bash
0 vote323 views1 answer
Virtualbox boot from usb
Shell/Bash
0 vote344 views1 answer
Copy files from certain date linux
Shell/Bash
0 vote315 views1 answer
Remove docker completely orcal linx
Shell/Bash
0 vote334 views1 answer
Linux subsystem mount file into windows
Shell/Bash
75 votes338 views6 answers
Kill ubuntu port
Shell/Bash
1 vote346 views1 answer
Install yacc on ubuntu
Shell/Bash