Pokemon data native in DuckDB
Maintainer(s):
Ian-Fogelman
Installing and Loading
INSTALL psyduck FROM community;
LOAD psyduck;
Example
-- Install the Psyduck Extension
INSTALL psyduck
LOAD psyduck
-- Create a table of pokémon and return... A duck
CREATE TABLE pokemon AS SELECT * FROM list_pokemon();
SELECT name FROM pokemon WHERE is_duck = 1 AND name LIKE '%Psyduck%';
-- Select the top 10 pokémon
SELECT * FROM list_pokemon() WHERE number <= 10;
-- Select legendary pokémon
SELECT * FROM list_pokemon() WHERE is_legendary = 1;
-- Select the best pokémon
SELECT number, name, type1, "height(m)", "weight(kg)", base_total FROM list_pokemon() WHERE name = 'Charizard';
Added Functions
function_name | function_type | description | comment | examples |
---|---|---|---|---|
list_pokemon | table | NULL | NULL |