/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

0 vote121 views1 answer
Debian buster add ip alias cli
Shell/Bash
93 votes130 views6 answers
How to create an environment in conda
Shell/Bash
4 votes196 views1 answer
Open folder from terminal in kali
Shell/Bash
0 vote162 views1 answer
Git branch -M main not working
Shell/Bash
5 votes195 views1 answer
Install module to current directory pip
Shell/Bash
2 votes90 views2 answers
Download phpmyadmin mac
Shell/Bash
0 vote126 views1 answer
Mac m1 Error running pod install
Shell/Bash
1 vote189 views1 answer
Or in matlab
Shell/Bash
6 votes151 views3 answers
Node js request
Shell/Bash
0 vote122 views1 answer
Prometheus reload
Shell/Bash