| 246 | {{{ |
| 247 | psql (16.4 (Ubuntu 16.4-0ubuntu0.24.04.2)) |
| 248 | }}} |
| 249 | |
| 250 | {{{ |
| 251 | user=# \du |
| 252 | List of roles |
| 253 | Role name | Attributes |
| 254 | -----------+------------------------------------------------------------ |
| 255 | postgres | Superuser, Create role, Create DB, Replication, Bypass RLS |
| 256 | user | Superuser, Create role, Create DB |
| 257 | |
| 258 | user=# create extension |
| 259 | address_standardizer intagg pg_walinspect |
| 260 | "address_standardizer-3" intarray postgis |
| 261 | address_standardizer_data_us isn "postgis-3" |
| 262 | "address_standardizer_data_us-3" lo postgis_raster |
| 263 | adminpack ltree "postgis_raster-3" |
| 264 | amcheck moddatetime postgis_tiger_geocoder |
| 265 | autoinc ogr_fdw "postgis_tiger_geocoder-3" |
| 266 | bloom old_snapshot postgis_topology |
| 267 | btree_gin pageinspect "postgis_topology-3" |
| 268 | btree_gist pg_buffercache postgres_fdw |
| 269 | citext pgcrypto refint |
| 270 | cube pg_freespacemap seg |
| 271 | dblink pg_prewarm sslinfo |
| 272 | dict_int pgrouting tablefunc |
| 273 | dict_xsyn pgrowlocks tcn |
| 274 | earthdistance pg_stat_statements tsm_system_rows |
| 275 | file_fdw pgstattuple tsm_system_time |
| 276 | fuzzystrmatch pg_surgery unaccent |
| 277 | hstore pg_trgm "uuid-ossp" |
| 278 | insert_username pg_visibility xml2 |
| 279 | |
| 280 | }}} |
| 281 | |