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

From wikieduonline
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 26: Line 26:
 
== Related ==
 
== Related ==
 
* [[List extensions]]
 
* [[List extensions]]
* [[timescaledb_toolkit]]
+
* <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: