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

From wikieduonline
Jump to navigation Jump to search
Line 9: Line 9:
 
  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        |          |

Revision as of 06:02, 25 October 2022

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)


See also

Advertising: