Suggested way of associating PG user metadata with record
От
Peter Geoghegan
Тема
Suggested way of associating PG user metadata with record
Дата
Msg-id
db471ace0905200328r483774d3s90d511822595137@mail.gmail.com
Список
Дерево обсуждения
Suggested way of associating PG user metadata with record Peter Geoghegan <peter.geoghegan86@gmail.com>
Re: Suggested way of associating PG user metadata with
record David <wizzardx@gmail.com>
Re: Suggested way of associating PG user metadata with
record Peter Geoghegan <peter.geoghegan86@gmail.com>
Re: Suggested way of associating PG user metadata with
record David <wizzardx@gmail.com>
Re: Suggested way of associating PG user metadata with
record Peter Geoghegan <peter.geoghegan86@gmail.com>
Hello, I'd like to associate the PG user who created certain sorts of records with that record in my application. The obvious way to do this is by creating a text column with a default value of current_user in the record's table, or perhaps something similar with a trigger. However, because what I've described strikes me as a fairly common requirement, I suspect there may be a purpose-built, more direct and efficient feature I could use, such as a referential user datatype or something like that. Is there? If not, does the obvious approach seem reasonable? Regards, Peter Geoghegan
В списке pgsql-general по дате отправления