tags:

views:

5

answers:

1
Q: 

How can I know what are all the tables I have updated today in psql?

Hi Friends,

How can I know what are all the tables I have updated today in psql? Can anyone tell me.

Thanks in Advance.

+1  A: 

If you want to know such things, add a updatedBy (varchar login) and an updated (timestamp) column to every table.

Next, add a trigger to reach table which updates these two columns on INSERT and UPDATE.

Then you can run a query that gets you all tables plus a batch of queries which check in which tables something was updated by you.

If you want to see deletes, too, you will have to create another trigger which logs deletes but you need a different table for that or you must be able to mark all rows in all tables as "deleted" somehow without deleting them.

Aaron Digulla  2010-08-19 13:56:20

related questions

Date split-up based on break-up
PostgreSQL: Log query only on error
Date split-up based on Fiscal Year
Combining two resources PHP
Postgres: clear entire database before re-creating / re-populating from bash script
PSQL 8.3+ client query results display
PSQL select max value per minute per id for multiple values a minute per id?
Copy data from Postgresql to MySQL
Altering Oracle sequence using result of expression
Making Postgres accessible in Firefox by Psql
Detecting errors to decide whether to rollback or commit
How to find child tables that inherit from another table in PSQL
Postgres serialization error without serializable transactions.
Postgresql restore Error at or near "`"
Using parameterized SQL with LIKE in WHERE clause (Pervasive SQL)
PostgreSQL return setof record ( virtual table )
How Do I Backup My PostgreSQL Database with Cron?
Is there a good reference card that compares T-SQL and PL/SQL side-by-side?
Determining the start and end range of bytes changed in a file
Why is psql inserting a tilde when I press any of the keys in the Home key cluster?
How do I move a Pervasive PSLQ database between servers
Using psql to run an update
Querying data from different tables
postgreSQL - psql \i : how to execute script in a given path
PostgreSQL "DESCRIBE TABLE"