Top "Psql" questions

Primary interactive shell for PostgreSQL.

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

postgresql psql table-structure
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my …

postgresql command-line psql
How to switch databases in psql?

In MySQL, I used use database_name; What's the psql equivalent?

postgresql psql
How to exit from PostgreSQL command line utility: psql

What command or short key can I use to exit the PostgreSQL command line utility psql?

postgresql postgresql-9.1 psql
psql: FATAL: database "<user>" does not exist

I'm using the PostgreSql app for mac (http://postgresapp.com/). I've used it in the past on other machines but …

postgresql psql
postgresql port confusion 5433 or 5432?

I have installed postgresql on OSX. When I run psql, I get $ psql psql: could not connect to server: No …

postgresql port psql
List tables in a PostgreSQL schema

When I do a \dt in psql I only get a listing of tables in the current schema (public by …

postgresql postgresql-9.1 psql
Find the host name and port using PSQL commands

I have PSQL running, and am trying to get a perl application connecting to the database. Is there a command …

postgresql psql
Postgresql: Scripting psql execution with password

How can I call psql so that it doesn't prompt for a password? This is what I have: psql -Umyuser &…

postgresql psql
psql - save results of command to a file

I'm using psql's \dt to list all tables in a database and I need to save the results. What is …

postgresql psql