Suggested way of associating PG user metadata with record

Поиск
Список
Период
Сортировка
Искать
От
Peter Geoghegan
Тема
Suggested way of associating PG user metadata with record
Дата
в 07:28:53
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 по дате отправления
От: Raymond O'Donnell
Дата:
От: David
Дата:
FAQ