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;