Top "Psql" questions

Using psql how do I list extensions installed in a database?

How do I list all extensions that are already installed in a database or schema from psql? See also Finding …

postgresql psql postgresql-extensions

psql: command not found Mac

I installed PostgreSQL via the graphical install on http://www.postgresql.org/download/macosx/ I see it in my applications …

macos bash postgresql psql

The Response content must be a string or object implementing __toString(), "boolean" given after move to psql

As soon as I move my Laravel App from MySQL to pSQL. I kept getting this error. The Response content …

php mysql laravel laravel-5 psql

Shell script to execute pgsql commands in files

I am trying to automate a set of procedures that create TEMPLATE databases. I have a set of files (file1, …

bash postgresql psql

dynamic sql query in postgres

I was attempting to use Dynamic SQL to run some queries in postgres. Example: EXECUTE format('SELECT * from result_%s_…

postgresql dynamic-sql psql

Calling functions with exec instead of select

Is the default way of calling a function select * from my_function()? I ask because I have built a function …

postgresql psql

PostgreSQL user listing

I want to get a list of users for a certain database in psql - for example "template0". Who are …

postgresql privileges psql

Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib

I just installed posgresql with homebrew and when I go on to type the command psql I get the following …

postgresql psql libreadline

PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement

I've got this PL/pgSQL function which must return some users information. CREATE OR REPLACE FUNCTION my_function( user_id …

postgresql function stored-procedures plpgsql psql

Where is psql client history kept? (~/.psql_history non-existent!)

A password is visible in my psql prompt (by pushing up arrow to view previous inputted commands). So I would …

postgresql psql