You added a column to a PostgreSQL view. Now you want it gone. You ran CREATE OR REPLACE VIEW with fewer columns and PostgreSQL stopped you cold: Your table is fine. Your data is safe. But CREATE OR REPLACE VIEW has one hard rule — it can add columns at the end, but it cannot Read more about Cannot Drop Columns from View in PostgreSQL — Fix [42P16][…]
In our last blog we have discussed the history of origination of PostgreSQL database. This database, like all other RDBMS, has more than one interface to connect to the database. PostgreSQL has psql program as command line interface (CLI) and PgAdmin as graphical user interface (GUI) Validated on PostgreSQL 14, 15, and 16. Commands work Read more about PostgreSQL Meta-Command using psql: Generic Information[…]
PostgreSQL 12 installation on CentOS 7 fails silently when the YUM repository is missing or the wrong default version gets pulled. CentOS 7 defaults to PostgreSQL 9.2 — not version 12. Without explicitly specifying the version and setting up the PGDG repository first, the install either pulls the wrong version or breaks mid-transaction. This post Read more about PostgreSQL Installation on CentOS 7[…]