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

From wikieduonline
Jump to navigation Jump to search
 
(4 intermediate revisions by 2 users not shown)
Line 4: Line 4:
 
   extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
 
   extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
 
  ---------+----------+--------------+----------------+------------+-----------+--------------
 
  ---------+----------+--------------+----------------+------------+-----------+--------------
   plpgsql |      10 |          11 | f              | 1.0        |          |
+
   [[plpgsql]] |      10 |          11 | f              | 1.0        |          |
 
  (1 row)
 
  (1 row)
  
Line 21: Line 21:
 
  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","        +
 
  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' ","","","","","","","","","","","","","","",""}
 
       |            |          |              |                |            |                                                                                                                                                                                                        |  WHERE KEY = 'exported_uuid' ","","","","","","","","","","","","","","",""}
(2 rows)
+
(2 rows)
  
  
 
== Related ==
 
== Related ==
 
* [[List extensions]]
 
* [[List extensions]]
 +
* <code>[[timescaledb_toolkit]]</code>
  
 
== See also ==
 
== See also ==
 +
* {{create extension}}
 
* {{PostgreSQL extensions}}
 
* {{PostgreSQL extensions}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 14:57, 19 December 2024

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[edit]

See also[edit]

Advertising: