Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re^3: Hashing temporal tables in PostgreSQL

by erix (Prior)
on Sep 22, 2017 at 06:20 UTC ( [id://1199879]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Hashing temporal tables in PostgreSQL
in thread Hash generate and find tampered tables in PostgreSQL

I don't really see the problem. That oracle get_dll() just gets you the metadata. Every database can give you metadata.

An easy way in postgres is to use the views in schema information_schema. To see a list in psql:

\dv information_schema.
select table_schema , table_name , data_type from information_schema.columns where table_schema = 'public' and table_name= 'pgbench_accounts' order by ordinal_position;

and use something like that to md5 (or another checksum), either as a whole or on a row-by-row basis, or both.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1199879]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (3)
As of 2024-04-19 04:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found