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

From wikieduonline
Jump to navigation Jump to search
Line 26: Line 26:
 
== Related ==
 
== Related ==
 
* [[List extensions]]
 
* [[List extensions]]
 +
* [[timescaledb_toolkit]]
  
 
== See also ==
 
== See also ==

Revision as of 05:55, 4 July 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: