backendgym backendgym — reps Sign in with GitHubSign in

0404 · Import through staging

sql-designing-and-writing / reps/04/README.md

Inside a transaction, create a temporary CSV staging table, load two station rows with COPY, and insert them into stations with trimmed names. Return the inserted station IDs and names, then roll back so the seed remains available to the next rep.

Expected: 2 rows. The imported names have no leading or trailing spaces, and no permanent station remains after the statement finishes.

bgym run 4