HypoPG command
Goal
- Check if the
hypopg
extension exists - Automatically run the command
CREATE EXTENSION hypopg;
- Register Joe commands(make commands pluggable)
- First step to refactor commands
TODO / How to implement
Index management operations:
-
hypo CREATE INDEX ON hypo (id)
- create a hypothetical index -
hypo desc
- describe all hypothetical indexes -
hypo desc id
- describe hypothetical index -
hypo drop id
- drop a hypothetical index -
hypo reset
- drop all hypothetical indexes
The command hypo CREATE..
will:
- run a query like
SELECT * FROM hypopg_create_index('CREATE INDEX ON hypo (id)');
- return an id of the created index
Acceptance criteria
Edited by Artyom Kartasov