Question : I have a 100 csv files named sequentially 1,2,3….100.csv I copy the csv files with this script: COPY […]
Tag: csv
What MySQL data types REQUIRE a max length (size) declaration in a create table statement?
Question : I am converting a SQL Server table structure to a MySQL table structure, and I need to know […]
how to convert my PostgreSQL database table into CSV? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Generate CSV Email For Each UserID In Table
Question : Good day all, I have a unique requirement where I need to generate a .csv file containing data […]
Bulk load data and provide row-by-row feedback
Question : We want to allow our users to import CSV files containing many thousands of records to “pre-load” a […]
Bulk table creation and import of data
Question : I have a around 400 CSV files which have been exported from an old Paradox database, with each […]
Oracle XMLAGG issue with combining cells that have comma separated values in cells
Question : Have a situation where I’m trying to use xmlagg to get: | ID | name row1 | 1 […]
Does the PostgreSQL COPY command have the option of choosing which fields to map the CSV columns to?
Question : Does the PostgreSQL COPY command have the option of choosing which fields to map the CSV columns to? […]
How to troubleshoot COPY FROM inserting less rows then expected?
Question : I have a CSV (tab-delimited in fact) file with 7,590,051 lines, according to wc -l, which I want […]
Can’t import flat file into SqlServer
Question : I’ve got this tab-delimited flat file with fifty columns and two million rows. I am trying to import […]