This plugin adds PostgreSQL support to OctoSQL.

octosql plugin install postgres

The available configuration variables are:

• host
• port
• user
• password
• database
• schema

An example octosql.yml file would be:

databases:
  - name: mydb
    type: postgres
    config:
      host: localhost
      port: 3306
      database: mydatabase
      schema: public
      user: myuser
      password: mypassword

You can also set the OCTOSQL_POSTGRES_QUERY_LOGGING environment variable to 1 to enable detailed query logging. They will then be visible in your ~/.octosql/logs.txt file.

After configuring a database as described above you can use tables from the configured database in your OctoSQL queries:

octosql "SELECT * FROM mydb.mytable" --describe
octosql "SELECT COUNT(*) FROM mydb.mytable"