Deleted Records & file format

Started by Jonathan Bond-Caronabout 16 years ago1 messagesgeneral
Jump to latest
#1Jonathan Bond-Caron
jbondc@openmv.com

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?