Top "Psql" questions

Primary interactive shell for PostgreSQL.

How to Add, Delete new Columns in Sequelize CLI

I've just started using Sequelize and Sequelize CLI Since it's a development time, there are a frequent addition and deletion …

node.js sequelize.js psql sequelize-cli
Postgresql not creating db with “createdb” as superuser, yet not outputting errors

I am working with a fresh postgresql install, with 'postgres' super user. Logged in via: sudo -u postgres psql postgres=# …

postgresql psql
how to execute .sql files in postgres database

I am using postgres database with PostGIS and PGAdmin. I have many .sql files with different sizes like 300MB, 280MB …

postgresql psql
How to set timezone for Postgres psql?

How do I set timezone for psql to something other than my default (US/Central)? Here's what I've tried so …

postgresql timezone psql
Correct way to install psql without full Postgres on macOS?

Official page do not mention such case. But many users need only psql without a local database (I have it …

macos postgresql psql macos-sierra
PG::UndefinedTable: ERROR: missing FROM-clause entry for table when using joins and where

I have two models, Courier and Order. I have the following query below: active_couriers = Courier. available_courier_status. where(:…

ruby-on-rails ruby-on-rails-4 psql
Use pg_restore to restore from a newer version of PostgreSQL

I have a (production) DB server running PostgreSQL v9.0 and a development machine running PostgreSQL v8.4. I would like to …

postgresql export restore psql pg-dump
PostgreSQL Nested JSON Querying

On PostgreSQL 9.3.4, I have a JSON type column called "person" and the data stored in it is in the format {…

json postgresql psql postgresql-9.3
can't grant user privileges to postgresql database (for a rails app)

I combed through: http://www.postgresql.org/docs/current/interactive/app-psql.html#APP-PSQL-META-COMMANDSf and https://www.digitalocean.com/community/articles/…

postgresql psql
psql - loop variable of loop over rows must be a record or row variable or list of scalar variables

Here is my simple anonymous code block: do $$ declare foo varchar(50) := ''; begin for a in select a from (values(…

postgresql psql