Top "Psql" questions

Primary interactive shell for PostgreSQL.

Run batch file with psql command without password

I am trying to execute this psql command using a batch script: psql --host=localhost --dbname=<dbname> --port=&…

postgresql shell connection psql
How restore a PostgreSQL table from *.sql using pg_dump or psql?

I need to restore a big table (250mb) in PostgreSQL database in console tool. How I can do this using …

postgresql dump psql
How can I connect to a postgreSQL database into Apache Spark using scala?

I want to know how can I do following things in scala? Connect to a postgreSQL database using Spark scala. …

scala apache-spark psql
Import postgres database without roles

I have a database that was exported with pg_dump, but now when I'm trying to import it again with: …

sql database postgresql import psql
Postgresql - unrecognized configuration parameter

I exported a postgresql database from an external server, and attempted to import it into my local server but got …

postgresql psql
How to start psql.exe

I'm new to postgresql (pg). I understand that in order to interact with pg, I must use psql.exe. In …

windows postgresql psql
How to put psql on the path when using Postgres.app on OS X?

I've installed Postgres93 on my Mac. I can open the application, and "Open psql" through the app which opens up …

macos postgresql psql
How to execute *.sql file using psql

I have created an index.sql file which contains index creating script for 95 table for example DROP INDEX IF EXISTS …

postgresql psql
Postgres JSON data type Rails query

I am using Postgres' json data type but want to do a query/ordering with data that is nested within …

json postgresql ruby-on-rails-4 rails-postgresql psql
psql: FATAL: too many connections for role

I tried connecting to the database server using the command: psql -h host_ip -d db_name -U user_name …

sql postgresql connection psql