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

From wikieduonline
Jump to navigation Jump to search
Line 6: Line 6:
 
   plpgsql |      10 |          11 | f              | 1.0        |          |
 
   plpgsql |      10 |          11 | f              | 1.0        |          |
 
  (1 row)
 
  (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 ==
 
== See also ==

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: