How to add column if not exists on PostgreSQL?
Question is simple. How to add column x to table y, but only when x column doesn’t exist ? I found only solution … Read more
postgresql-9.1
Change type of varchar field to integer: “cannot be cast automatically to type integer”
I have a small table and a certain field contains the type “character varying“. I’m trying to change it to “Integer” but it … Read more
PostgreSQL ERROR: canceling statement due to conflict with recovery
I’m getting the following error when running a query on a PostgreSQL db in standby mode. The query that causes the error works … Read more
I forgot the password I entered during postgres installation
I either forgot or mistyped (during the installation) the password to the default user of Postgres. I can’t seem to be able to … Read more
must appear in the GROUP BY clause or be used in an aggregate function
I have a table that looks like this caller ‘makerar’ cname | wmname | avg ——–+————-+———————— canada | zoro | 2.0000000000000000 spain | … 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
How to exit from PostgreSQL command line utility: psql
What command or short key can I use to exit the PostgreSQL command line utility psql? 8 Type \q and then press ENTER … Read more