System column ctid as row identifier

In Oracle we have system column ROWID which something like “address of the row id Oracle datafile”. This ROWID is unique because beside of table and row signature it contains also signature of datafile. Oracle stores everything in big datafiles and have...

Analyze data file

So far I did not find any tool which could help me to analyze content of some table’s data file. And sometimes it is really useful even necessary to see what was in deleted records. Therefore I tried to decode data file using program in python. Simple version is...

Where database stores data / PostgreSQL data directory

show data_directory result (example from Windows): “C:/Program Files/PostgreSQL/9.4/data” Can be used in Linux bash script this way: datadir=$(psql -U postgres -t -c "show data_directory") But sometimes things are not so easy – if you do...