_add-timescaledb-to-a-database.md

1. Connect to a database on your $PG instance

   In $PG, the default user and database are both postgres. To use a different database, set <database-name> to the name of that database:

   psql -d "postgres://<username>:<password>@<host>:<port>/<database-name>"

2. Add $TIMESCALE_DB to the database

   CREATE EXTENSION IF NOT EXISTS timescaledb;

3. Check that $TIMESCALE_DB is installed

   \dx

   You see the list of installed extensions:

   List of installed extensions
   Name     | Version |   Schema   |                                      Description                                      
   -------------+---------+------------+---------------------------------------------------------------------------------------
   plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language
   timescaledb | 2.17.2  | public     | Enables scalable inserts and complex queries for time-series data (Community Edition)

   Press q to exit the list of extensions.