Top "Psql" questions

Primary interactive shell for PostgreSQL.

How to ignore errors with psql \copy meta-command

I am using psql with a PostgreSQL database and the following copy command: \COPY isa (np1, np2, sentence) FROM 'c:\…

postgresql error-handling psql postgresql-copy
keystroke to clear screen in psql?

I want a shortcut key to clear the screen in my (Windows 7) psql console just like CTRL-l clears the screen …

psql postgresql-9.3
Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy

I'm trying to import data from a .csv file into a postgresql 9.2 database using the psql \COPY command (not the …

postgresql csv timestamp psql postgresql-9.2
pg_stat_statements enabled, but the table does not exist

I've postgresql-9.4 up and running, and I've enabled pg_stat_statements module lately by the help of official documentation. But …

postgresql psql pg-stat-statements
How do I run a sql file of inserts through docker run?

I have the following file of inserts: INSERT INTO countries (id, country_code, name, ios3, numcode, withdrawn) VALUES (1, 'AF', 'Afghanistan', …

docker psql
How do I declare variables in pgAdmin

If I am in the psql terminal then I can declare and use a variable like this: \set message_id …

postgresql variables psql pgadmin
Postgresql is the server running locally and accepting connection on Unix domain

I am trying to install postgresql-9.5 or postgresql-9.6 on my ubuntu 16.04 or 14.04 machine, after following the installation process using below …

postgresql ubuntu-14.04 ubuntu-16.04 psql postgresql-9.4
Show query result column types (PostgreSQL)

Is there a way to easily get the column types of a query result? I read the psql documentation, but …

postgresql psql
Insert SQL statements via command line without reopening connection to remote database

I have a large amount of data files to process and to be stored in the remote database. Each line …

database postgresql shell connection psql
Installed Postgres.app but it won't work

I just installed Postgres.app on my Mac but it won't work properly. I finished the installation and the app …

postgresql heroku psql