Postgresql easy
PostgreSQL can be extended with external modules (like PostGIS or pg_trgm). Which SQL command is used to enable these extensions in a database?
- A LOAD MODULE: Loads specific C libraries into the current system session.
- B IMPORT EXTENSION: Copies the module code from a remote Git repository.
- C CREATE EXTENSION: Registers the module's functions and types in the DB.
- D ENABLE PLUGIN: Switches on the specific features within the admin panel.
Answer: C. CREATE EXTENSION: Registers the module's functions and types in the DB.
`CREATE EXTENSION` is the dedicated command to load pre-packaged modules into a specific database. This allows users to add specialized capabilities like GIS support or fuzzy-search without modifying the core server.
One system design question a day, with spaced repetition so the ones you miss come back.
Get the appRelated questions
- In a PostgreSQL environment, what functional characteristic distinguishes a `MATERIALIZED VIEW` from a standard `VIEW`?
- Which standard PostgreSQL utility is designed to extract a single database into a script or archive file for backup purposes?
- Why would PostgreSQL reject a `DELETE` operation on a record despite the user having full administrative privileges?
- The 'Heap Only Tuples' (HOT) optimization improves UPDATE performance. Which specific set of conditions must be met for a HOT update to occur?
- Which native command-line utility is used to execute SQL queries and manage PostgreSQL databases from a terminal session?
- What is the specific purpose of 'Freezing' a row (modifying its `xmin` status) during a major VACUUM operation?