Difference between revisions of "PostgreSQL extensions"

From wikieduonline
Jump to navigation Jump to search
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
 
 
  [[CREATE EXTENSION]]
 
  [[CREATE EXTENSION]]
 
  [[CREATE EXTENSION pg_stat_statements]];
 
  [[CREATE EXTENSION pg_stat_statements]];
 +
[[CREATE EXTENSION]] [[uuid-ossp]]
 +
 +
* List available extensions: [[~/brew/share/postgresql@17/extension/]]
  
 
[[List extensions]]:
 
[[List extensions]]:
 
* <code>[[SELECT * FROM pg_extension;]]</code>
 
* <code>[[SELECT * FROM pg_extension;]]</code>
 
* <code>SELECT * FROM [[pg_available_extensions]];</code>
 
* <code>SELECT * FROM [[pg_available_extensions]];</code>
 +
* <code>[[\dx]]</code>
  
  
Line 19: Line 21:
 
* <code>[[plpgsql]]</code>
 
* <code>[[plpgsql]]</code>
 
* [[Temporal database]]
 
* [[Temporal database]]
 +
* [[brew install postgresql]]
  
 
== See also ==
 
== See also ==

Latest revision as of 15:30, 19 December 2024

Advertising: