psql Archives - IT Nursery

Programming, sql

IT Nursery

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 ...

June 2, 2022
0 Comments

postgresql, Programming

IT Nursery

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 ...

May 28, 2022
0 Comments

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 ...

May 22, 2022
0 Comments

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 ...

May 21, 2022
0 Comments

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 ...

May 21, 2022
0 Comments

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 ...

May 12, 2022
0 Comments

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, ...

May 12, 2022
0 Comments

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 ...

May 11, 2022
0 Comments

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 ...

May 8, 2022
0 Comments

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 ...

May 6, 2022
0 Comments