Posts

Showing posts with the label c.relhasoids

PostgreSQL(psql): ERROR: column c.relhasoids does not exist

Image
  I’m trying to   DESCRIBE TABLE   with a command in Postgresql. For some types of relation,   \d   shows additional information for each column: column values for sequences, indexed expressions for indexes, and foreign data wrapper options for foreign tables. So I punch in  \d table_name , I keep getting an error below. ERROR: column c.relhasoids does not exist LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi... Solution The error only appears if you are using  Postgres v.12, 13, 14  (12 or newer) and older  psql  client  v.11  or  earlier . In my case, I used  psql  client  9.4.5  and  Postgres  server  14.4 . (jobsites_env)nksm@Ubuntu- 1410 /home/nieuwejobs/trunk # python manage.py dbshell psql ( 9.4 . 5 , server 14.4 (Ubuntu 14.4 - 1 .pgdg22. 04 + 1 )) WARNING: psql major version 9.4 , server major version 14.4 . Some psql features might not work. Ty...