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 the correct command to alter the data type of a column? 3 Answers 3
I have PSQL running, and am trying to get a perl application connecting to the database. Is there a command to find the current port and host that the database is running on? 15 Answers 15
I just installed posgresql with homebrew and when I go on to type the command psql I get the following error: dyld: Library not loaded: /usr/local/opt/readline/lib/libreadline.6.2.dylib Referenced from: /usr/local/bin/psql Reason: image not found [1] 69711 trace trap psql Does anyone have any idea about what’s wrong? 22 Answers 22
I have a postgres database with multiple schemas. When I connect to the database from a shell with psql and I run \dt it uses the default connection schema which is public. Is there a flag I can specify or how can I change the schema? 10 Answers 10
Official page do not mention such case. But many users need only psql without a local database (I have it on AWS). Brew do not have psql. 7 Answers 7
How do I list all extensions that are already installed in a database or schema from psql? See also Finding a list of available extensions that PostgreSQL ships with 3 Answers 3
How can I call psql so that it doesn’t prompt for a password? This is what I have: psql -Umyuser < myscript.sql However, I couldn’t find the argument that passes the password, and so psql always prompts for it. 16 Answers 16
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 export the results of a psql command to a file? 10 Answers 10
I am using PostgreSQL 8.4 on Ubuntu. I have a table with columns c1 through cN. The columns are wide enough that selecting all columns causes a row of query results to wrap multiple times. Consequently, the output is hard to read. When the query results constitute just a few rows, it would be convenient … Read more
When I do a \dt in psql I only get a listing of tables in the current schema (public by default). How can I get a list of all tables in all schemas or a particular schema? 5 Answers 5
