Category Archives: postgres

Looking up Postgres table name by id

When working with [TOAST][1] tables, I had the relid (relation or table id) of the parent table, and needed to get its name. Here is how to perform the lookup. For example, if the relid is 19665: SELECT relid, relname … Continue reading

Posted in postgres | Leave a comment