Files
sqlpage--sqlpage/tests/uploads/upload_csv_test.sql
2025-05-25 23:20:31 +02:00

6 lines
317 B
SQL

drop table if exists sqlpage_people_test_table;
create table sqlpage_people_test_table(name text, age text);
copy sqlpage_people_test_table(name, age) from 'people_file' with (format csv, header true);
select 'text' as component,
name || ' is ' || age || ' years old. ' as contents
from sqlpage_people_test_table;