9 lines
209 B
Bash
9 lines
209 B
Bash
|
#!/bin/bash
|
||
|
|
|
||
|
|
# Boucle sur chaque ligne
|
||
|
|
psql -h 127.0.0.1 -d sql -U sql -At -c \
|
||
|
|
"SELECT id, data::text FROM item" |
|
||
|
|
while IFS=$'\|' read -r id json; do
|
||
|
|
echo "$json" | jq -S '.' > "data/json/${id}.json"
|
||
|
|
done
|