Top "Psql" questions

Primary interactive shell for PostgreSQL.

How to solve PostgreSQL pgAdmin error "Server instrumentation not installed" for adminpack?

PostgreSQL 9.1 pgAdmin III on Ubuntu is giving this warning: Guru Hint - Server instrumentation not installed Server Instrumentation The server …

postgresql ubuntu pgadmin psql
will pg_restore overwrite the existing tables?

Say I have two host servers s1 and s2. In both the servers i have a schema named n1, now …

postgresql psql postgresql-9.5 pg-dump pg-restore
using define statement in PL/SQL developer

This is one of the tasks from my homework assignement: DEFINE countryid = CA DECLARE country_record countries%ROWTYPE; BEGIN SELECT * …

sql oracle plsqldeveloper psql
How to return a value from psql to bash and use it?

Suppose I created a sequence in postgresql: CREATE SEQUENCE my_seq; I store the below line in an sql file …

postgresql psql
psql: permission denied for database "dbname" ("User does not have CONNECT privilege.") / "unrecognized role option 'connect'"

when I try to login to my database with psql, doing this: psql dbname --username=qgis --password >>(prompts …

postgresql login connect role psql
Datatype for a URL in PostgreSQL

I need to store a URL in a PostgreSQL table. What is the best datatype for a field that will …

postgresql url psql
PostgreSQL: Drop Database but DB is still there

I am new to PostgreSQL and I try to get my head around it. I am familiar to db's and …

postgresql psql
How to Drop/Create Database name that has upper-case letter?

for example my Postgresql database name is Ajp i cannot drop/create the db with this name ie. Ajp my …

postgresql psql
Why psql can't find relation name for existing table?

Here' my current state. Eonil=# \d+ List of relations Schema | Name | Type | Owner | Size | Description --------+------------+-------+-------+------------+…

postgresql schema psql
Is there a "pg_restore --quiet" option like "psql --quiet"?

psql has a -q / --quiet option (environment variable QUIET). pg_restore does not have a quiet option. Is there any …

postgresql postgresql-9.1 psql pg-restore