Difference between revisions of "SELECT * FROM pg extension;"

From wikieduonline
Jump to navigation Jump to search
Line 15: Line 15:
  
  
   oid  |  extname  | extowner | extnamespace | extrelocatable | extversion |                                                                                                extconfig                                                                                                |                                extcondition
+
SELECT * FROM pg_extension;
 +
   [[oid]] [[extname]]   | [[extowner]] | [[extnamespace]] | extrelocatable | extversion |                                                                                                extconfig                                                                                                |                                extcondition
 
  ------+-------------+----------+--------------+----------------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------
 
  ------+-------------+----------+--------------+----------------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------
 
  13747 | plpgsql    |      10 |          11 | f              | 1.0        |                                                                                                                                                                                                        |
 
  13747 | plpgsql    |      10 |          11 | f              | 1.0        |                                                                                                                                                                                                        |

Revision as of 14:53, 6 February 2023

SELECT * FROM pg_extension;

 extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
---------+----------+--------------+----------------+------------+-----------+--------------
 plpgsql |       10 |           11 | f              | 1.0        |           |
(1 row)
SELECT * FROM pg_extension;
 extname       | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
 --------------+----------+--------------+----------------+------------+-----------+--------------
plpgsql            |       10 |           11 | f              | 1.0        |           |
pg_stat_statements |       10 |         2200 | t              | 1.6        |           |
(2 rows)


SELECT * FROM pg_extension;
 oid  |   extname   | extowner | extnamespace | extrelocatable | extversion |                                                                                                extconfig                                                                                                |                                 extcondition
------+-------------+----------+--------------+----------------+------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------
13747 | plpgsql     |       10 |           11 | f              | 1.0        |                                                                                                                                                                                                         |
16385 | timescaledb |       10 |         2200 | f              | 2.9.2      | {16402,16403,16424,16437,16451,16450,16469,16482,16481,16497,16496,16521,16537,16538,16554,16567,16568,16612,16619,16646,16658,16668,16672,16688,16707,16722,16743,16755,16754,16771,16776,16782,16779} | {"","","","","","","","","","","","","","","","","WHERE id >= 1000","        +
      |             |          |              |                |            |                                                                                                                                                                                                         |   WHERE KEY = 'exported_uuid' ","","","","","","","","","","","","","","",""}

(2 rows)


Related

See also

Advertising: