PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

System Catalogs / System catalogs

pg_shseclabel

Read the PG 18 manual

The catalog pg_shseclabel stores security labels on shared database objects.

Reading PG 18current·documented in 16 of 24 versions, 9.2 to 20

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Kind: System catalogs
Columns in this snapshot: 4
Definition source: English manual
Metadata snapshot: 18.6

Columns 4

As listed in the PostgreSQL 18 manual.

Column	Type	Description / reference
`objoid`	`oid`NOT NULL	The OID of the object this security label pertains to
`classoid`	`oid`NOT NULL	The OID of the system catalog this object appears in pg_class.oid
`provider`	`text`NOT NULL	The label provider associated with this label.
`label`	`text`NOT NULL	The security label applied to this object.

Column history across versions

objoid

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

classoid

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

provider

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

label

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Version history 14

18 → 19 reworded
17 → 18 reworded
16 → 17 reworded
14 → 15 reworded
13 → 14 reworded
12 → 13 reworded
11 → 12 reworded
10 → 11 reworded
9.6 → 10 reworded
9.5 → 9.6 reworded
9.4 → 9.5 changed
9.3 → 9.4 reworded
9.2 → 9.3 reworded
9.1 → 9.2 added

Definition snapshot: english-manuals:028494bf0e48709c2ef74545a53… · English manual source