/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

8 votes171 views1 answer
Intsalling pycharm in ubuntu
Shell/Bash
4 votes188 views6 answers
Download mongodb ubuntu 20.04
Shell/Bash
10 votes180 views5 answers
Node version manager
Shell/Bash
0 vote162 views1 answer
Full path with linux find
Shell/Bash
0 vote175 views1 answer
Install memcache di linux
Shell/Bash
33 votes179 views6 answers
Install jupyter
Shell/Bash
0 vote180 views1 answer
Is not digitally signed. You cannot run this script on the current system
Shell/Bash
0 vote175 views1 answer
Docker alpine create user and group
Shell/Bash
1 vote171 views1 answer
Git update using git bash
Shell/Bash
1 vote171 views2 answers
Shell get all lines that are in one file and not another
Shell/Bash