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

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

Revision as of 06:00, 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: