Adatbáziskezelés (TTBML1440)

What is csvkit?

https://csvkit.readthedocs.io/en/latest/

Query from a database into a csv file

sql2csv --db "postgresql://gisadmin@localhost/danubefish" --query "select * from danubefish" > danubefish_data.csv

Query from a database to STDOUT

sql2csv --db "postgresql://gisadmin@localhost/danubefish" --query "select * from danubefish where \"equipment\" != 'cast net' "

Query from a DUMMY SQL server

sql2csv --query "select 300 * 47 % 14 * 27 + 7000"

Import several csv files into a database

This command also creates the table structure!

csvsql --db "postgresql://gisadmin@localhost/superspecies" --insert ssp_*