Top "Psql" questions

Primary interactive shell for PostgreSQL.

foreigner - remove foreign key

I am trying to use mailboxer in my rails 4 app. A problem is arising when i try to deploy the …

ruby-on-rails psql mailboxer foreigner
PostgreSQL: encoding problems on Windows when using psql command line utility

I'm working in a centralized monitoring system on Windows 2008 R2, I have installed a PostgreSQL 9.3 to use psql from the …

sql postgresql command-line character-encoding psql
How to generate a CREATE script for several tables in pgAdmin III?

In pgAdmin III you can: right-click a table; scripts; CREATE script; save the script from the SQL Editor. If one …

postgresql psql pgadmin phppgadmin
Display select results vertically in psql, as is done by MySQL's \G

In MySQL, you can terminate a select query with \G (as opposed to \g) to display the results vertically: select * …

postgresql psql
Remotely connecting to Postgres instance using psql command

I want to remotely connect to a Postgres instance. I know we can do this using the psql command passing …

postgresql psql
Postgres COPY FROM csv file- No such file or directory

I'm trying to import a (rather large) .txt file into a table geonames in PostgreSQL 9.1. I'm in the /~ directory of …

postgresql csv import psql tsv
How to use the psql command to list, create, use and examine databases?

I'm a postgreSQL newbie and I can't find any usable introduction to using the psql command. At least I think …

postgresql psql
Dockerizing PostgreSQL - psql Connection refused

I'm playing around with Docker and I would like to Dockerize a Postgres container. I'm following the official example but …

postgresql docker psql
ERROR: missing data for column when using \copy in psql

I'm trying to import a .txt file into PostgreSQL. The txt file has 6 columns: Laboratory_Name Laboratory_ID Facility ZIP_…

postgresql psql postgresql-copy
PostgreSQL error: could not connect to database template1: could not connect to server: No such file or directory

I need to create database. First I run: sudo su - postgres, then: createdb test And I keep getting this …

postgresql ubuntu psql