Top "Psql" questions

Primary interactive shell for PostgreSQL.

Show all the privileges for a concrete user

How to make a query to the Postgres data dictionary to find out all the privileges that a particular user …

postgresql postgresql-9.1 psql privileges
Restoring the data from pg_dump doesn't overwrite the data but it appends the data to the original database

I am taking the dump of postgres database using "pg_dump database_name > backup.sql". Later on I am …

postgresql backup psql restore pg-dump
customize pager in psql

When I use psql, the command line tool of PostgreSQL, in interactive mode, it lists data as paginated output. However, …

postgresql command-line psql pager
How to print current working directory in psql console?

I am trying to restore a schema on a remote server using the psql console in pgAdmin and an sql …

postgresql psql
psql: no relations found despite existing relations

Version 8.4.16 (no choice in version). I log into my db as follows: psql -d JRuser The resulting prompt is: JRuser=&…

sql postgresql schema psql
psql: FATAL: role "vagrant" does not exist

I created a vagrant instance and I am getting this error every time I try and do psql in the …

postgresql vagrant psql
Catch all error psql function exception

I am writing an function with exception catching and ignoring. I want to catch all the exceptions and just ignore …

exception-handling plpgsql psql
psql: FATAL: connection requires a valid client certificate

I am trying to connect to my PostgreSQL server but psql is complaining that I don't have a valid client …

postgresql ssl openssl psql
Disable wrapping in Psql output

When using Psql in Linux, if the result of my SQL query contains many columns or long strings of data, …

bash postgresql psql
How to scan a QueryRow into a struct with pgx

We are using a user struct with alot of fields as follow : type user struct { ID int `json:"id,omitempty"` …

go struct psql pgx