Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

csv into data postgres

COPY table_name FROM 'C:UsersPublicDocumentsert.txt' DELIMITER ',' CSV
-- make sure to put the file in public folder in windows 
-- Or temp folder in linux/mac 
-- because it might ask for some permissions...
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #csv #data #postgres
ADD COMMENT
Topic
Name
5+2 =