Skip to content

=$
|

  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact

Tag: pgaudit

How to log selects from specific table?

Someone, somewhere (on IRC or Slack), asked about logging read access to specific table.

This is interesting question with at least couple options. So, let's dig in…

Continue reading How to log selects from specific table?

Posted on 2022-07-042023-02-17|Tags audit, howto, log, logging, pgaudit, postgresql, select, view|2 Comments on How to log selects from specific table?

Search

Follow me

  • Comments RSS
  • Posts RSS

Popular Posts

  • Waiting for PostgreSQL 15 – JSON_TABLE 1k views | 0 comments
  • System roles – what, why, how? 300 views | 0 comments
  • Explaining the unexplainable – part 3 273 views | 0 comments
  • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 207 views | 0 comments
  • Explaining the unexplainable – part 2 191 views | 0 comments
  • Waiting for PostgreSQL 11 – Fast ALTER TABLE ADD COLUMN with a non-NULL default 151 views | 0 comments
  • “ERROR: operator does not exist: integer = text” how to fix it? 149 views | 0 comments
  • how to insert data to database – as fast as possible 107 views | 0 comments
  • explain.depesz.com. 105 views | 0 comments
  • Understanding pg_stat_activity 100 views | 0 comments

PostgreSQL

  • Documentation
  • Explain Analyze analyzer
  • IRC help channel
  • Mailing Lists search
  • PG Planet
  • PostgreSQL Home Page

About me

  • CPAN
  • GitLab
  • Linked In
  • Why upgrade PG?
  • explain.D.C
  • paste.D.C
  • Waiting for …
    • … PostgreSQL 16
    • … PostgreSQL 15
    • … PostgreSQL 14
    • … PostgreSQL 13
    • … PostgreSQL 12
    • … PostgreSQL 11
    • … PostgreSQL 10
    • … PostgreSQL 9.6
    • … PostgreSQL 9.5
    • … PostgreSQL 9.4
    • … PostgreSQL 9.3
    • … PostgreSQL 9.2
    • … PostgreSQL 9.1
    • … PostgreSQL 9.0
    • … PostgreSQL 8.5
    • … PostgreSQL 8.4
  • Projects
  • Contact