/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

2 votes318 views3 answers
Crt secure no warnings
Shell/Bash
0 vote342 views2 answers
Js code for webpage download progress bar
Shell/Bash
1 vote336 views1 answer
Testing cors
Shell/Bash
0 vote336 views1 answer
Atom disable shelling out for environment
Shell/Bash
0 vote356 views1 answer
Sudo apt-get $'update\r' E: Invalid operation update
Shell/Bash
1 vote327 views1 answer
Download ganache cli for windows
Shell/Bash
49 votes312 views3 answers
Linux check if a port is open
Shell/Bash
0 vote336 views1 answer
Change default operating system grub
Shell/Bash
0 vote337 views1 answer
Check if service is running server
Shell/Bash
0 vote317 views1 answer
Install react select
Shell/Bash