How to alter a column’s data type in a PostgreSQL table?
Entering the following command into a PostgreSQL interactive terminal results in an error: ALTER TABLE tbl_name ALTER COLUMN col_name varchar (11); What is … Read more
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 to find the … Read more
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 error: dyld: Library … Read more
How to select a schema in postgres when using psql?
I have a postgres database with multiple schemas. When I connect to the database from a shell with psql and I run \dt … Read more
Correct way to install psql without full Postgres on macOS?
Official page do not mention such case. But many users need only psql without a local database (I have it on AWS). Brew … Read more
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 a list of … Read more
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 < myscript.sql However, … Read more
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 the syntax to … Read more
Alternate output format for psql
I am using PostgreSQL 8.4 on Ubuntu. I have a table with columns c1 through cN. The columns are wide enough that selecting … Read more
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 default). How can … Read more