> SELECT \* FROM pg_class WHERE oid = 'pg_class'::regclass; This selects every c... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

e12e on March 25, 2023 | parent | context | favorite | on: March 20 ChatGPT outage: Here’s what happened

> SELECT * FROM pg_class WHERE oid = 'pg_class'::regclass;

This selects every column (*) from every table (ObjectID is of type regclass)?

anarazel on March 25, 2023 [–]

Sorry, I should have used something more standard - but it was what I had ready...

It just selects every column from a single table, pg_class. Which is where postgres stores information about relations that exist in the current database.

Consider applying for YC's Spring batch! Applications are open till Feb 11.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact