3 ms·
> SELECT * FROM pg_class WHERE oid = 'pg_class'::regclass; This selects every column (*) from every table (ObjectID is of type regclass)?
by e12e 4y ago
> SELECT * FROM pg_class WHERE oid = 'pg_class'::regclass;
This selects every column (*) from every table (ObjectID is of type regclass)?
- anarazel 4y agoSorry, 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.