|
Is there any documentation of the binary
format of the ‘base’ tables? I found that I can find where a table’s
data stored with: SELECT oid FROM pg_database WHERE datname =
current_database(); SELECT relfilenode, reltoastrelid FROM
pg_class WHERE relname = 'table'; /usr/local/pgsql/data/base/$oid/$relfilenode From what I understand, deleted records
should still be there unless vacuum removes them. Is that right? |
