Sql

Import .csv Into Psql

I had to import the list of the students of my school into Postgresql, so I converted xlsx files to a csv file and imported into psql. Log in DB and type the follwing line: 1 \copy students(grade, class, number, name) from '/home/bombwhale/Downloads/list/students.csv' delimiter ',' csv header; \copy is client-side command. Lots of posts were told me to use COPY command, but the COPY command brought file access permission denied
더 읽기

Go SQL에서 order by를 능동적으로 하기

정렬을... 내 마음대로 하고 싶을 수도 있잖아?