From: | Romain Billon-Grand <billongrand(at)hotmail(dot)fr> |
---|---|
To: | Forum postgres debutants <pgsql-novice(at)postgresql(dot)org> |
Subject: | Keeping track of updates/performances |
Date: | 2015-03-17 08:06:35 |
Message-ID: | DUB124-W51DFD7A86003923BAF5160CE030@phx.gbl |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello!
Please give me your advices about the best way to keep in each table those informations:name of the user who created a rowname of the last user who modified ittimestamp for creationtimestamp for last modification
1/ I have been looking for built in options in postgres but I guess I have to build it myself...?Of course if Postgres already does it I am very happy, and all of the following quetsions are useless but I did not find this in the documentation...
2/ Is there some SQL query to return the "usermane" from pg_catalog or something(I will manage access to the database giving every user a role in his name, those role belonging to group roles such as senior/junior/visitor...) I did not find this in the documentation.
Or, even if it exists, maybe I would better get it back from some user table such asCREATE TABLE users (username TEXT, role TEXT, id_user..); ??
for timestamps, I guess triggers would be the best way to do the job, but I would like to have the whole table updated automatically without having to include this in all my update quieries...
3/ once such a table is built like this for exampleCREATE TABLE track (creation TIMESTAMP, last_modification TIMESTAMP, created_by TEXT, lastmodified_by TEXT)
What would be the advantages and drawbacks of this :CREATE TABLE anytable(...) INHERITS (tracks)vs this: CREATE TABLE anytable (...) LIKE tracks?
Many thanks for your help!
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2015-03-17 08:50:56 | Re: Keeping track of updates/performances |
Previous Message | Luca Ferrari | 2015-03-16 17:23:37 | Re: psql sqlstate return code access |