Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: csv

import 100 csv files into postgresql

By adminPosted on January 29, 2023

Question : I have a 100 csv files named sequentially 1,2,3….100.csv I copy the csv files with this script: COPY […]

What MySQL data types REQUIRE a max length (size) declaration in a create table statement?

By adminPosted on January 27, 2023

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]

By adminPosted on January 22, 2023

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

By adminPosted on January 12, 2023

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

By adminPosted on January 3, 2023

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

By adminPosted on December 30, 2022

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

By adminPosted on December 28, 2022

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?

By adminPosted on December 26, 2022

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?

By adminPosted on December 24, 2022

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

By adminPosted on December 22, 2022

Question : I’ve got this tab-delimited flat file with fifty columns and two million rows. I am trying to import […]

  • 1
  • 2
  • 3
  • …
  • 11

Recent Posts

  • Help me define the tables in this scenario
  • Convert seconds into HH:MM:SS format in MySQL
  • Guaranteeing a FK relationship through multiple tables
  • Is it Possible to Recover Data from a BLACKHOLE table? [closed]
  • MySQL: sysbench test – InnoDB vs Memory tables
  • Why are virtual log files not always allocated in order?
  • Need help to understand how information_schema.TABLES get updated
  • unique constraint on a set
  • PostgreSQL, integer arrays, index for equality
  • What is the most performant way to group by and join high cardinality columns in column based table?
  • LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?
  • Is a process created in Oracle for every SQL statement?
  • How to select a row based on the maximum value of a column, when ties are expected
  • I am unable to join tables in correct manner
  • How often to backup database and what are the favoroble practices to do so [closed]
  • In Postgresql, after pg_dump the access privileges on the database itself are not restored
  • InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
  • Which version of SQL Server 2016 supports R
  • Design DB for users with different information fields?
  • WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding