Difference between revisions of "SELECT * FROM pg extension;"
Jump to navigation
Jump to search
| (12 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | SELECT * FROM pg_extension; | + | SELECT * FROM [[pg_extension]]; |
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) | ||
SELECT * FROM [[pg_extension]]; | SELECT * FROM [[pg_extension]]; | ||
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 | | | ||
[[pg_stat_statements]] | 10 | 2200 | t | 1.6 | | | [[pg_stat_statements]] | 10 | 2200 | t | 1.6 | | | ||
| − | (2 rows) | + | (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 == | ||
| + | * [[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:
