pmkhlv

Untitled

Apr 23rd, 2022
353
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS 002_DM_clients(
  2. client_id integer PRIMARY KEY,
  3. client_firstname varchar(50),
  4. client_lastname varchar(50),
  5. client_email varchar(50),
  6. client_phone varchar(20),
  7. client_city varchar(50)
  8. );
  9.  
  10. COPY BUFF_clients(client_id, client_firstname, client_lastname, client_email, client_phone, client_city)
  11. FROM '/lessons/3. Витрина наносит ответный удар/5. Как загрузить новый источник данных/Задание 2/clients.csv'
  12. DELIMITER ','
  13. CSV HEADER;
Advertisement
Add Comment
Please, Sign In to add comment