[GENERAL] Last insert/update/delete time for a table

2008-04-25 Thread Aleksander Kmetec - INTERA
Hi all, I'm in the process of writing a backup script which only dumps those tables which were changed in the last 24 hours. We have hundreds of tables (one per user), but most of them don't get changed very often, so there's no point in dumping them every night. Is there a way to get the tim

[GENERAL] Getting the search_path value for a query listed in pg_stat_activity output (feature request?)

2007-09-27 Thread Aleksander Kmetec - INTERA
Hi, all. Is there a way to find out which search_path a query is using? I have around 100 schemas, each of them containing the same set of tables. When the app connects it sets the search_path and then doesn't use the schema name anywhere again, which means that it's impossible to see which exa