try createdb, mess arround with unm and password stuff sudo can set it psql to run postgres stuff \d for tables \h for help \q to quit CREATE TABLE X (asdf varchar(10)) here INSERT SELECT etc # database on heroku, compatible with django and nodejs heroku addons:create heroku-postgresql npm install pg const { Client } = require('pg'); const client = new Client({ connectionString: process.env.DATABASE_URL, ssl: true, }); client.connect(); client.query('SELECT table_schema,table_name FROM information_schema.tables;', (err, res) => { if (err) throw err; for (let row of res.rows) { console.log(JSON.stringify(row)); } client.end(); });