Question : I have a few users who will be uploading a few types of predefined CSV files. I need […]
Tag: csv
Wildcard for meta-command in postgresql
Question : I am searching if there is a wildcard assigned to the meta-commandsSee description – meta-commands in Postgresql. for […]
Order the result of a comma separated string generated with STUFF
Question : Given a schema like this: CREATE TABLE Foo ( Id int PRIMARY KEY, Position int NOT NULL, Title […]
SQL Server Agent – Do not show job step details and column headers in output file
Question : I have a SQL Server Agent job which runs a select statement on a schedule and appends results […]
How to SELECT with two CSV files/… on PostgreSQL? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Import daily csv with varying available headers
Question : I receive a csv daily from an external company capturing feedback for us. Unhelpfully the csv headings vary. […]
postgresql – Importing CSV Data with Custom Type
Question : I’m mostly a newcomer to databases and am building a postgres database of student achievement in a series […]
How to export data in Oracle database into CSV file with UTF-8 format?
Question : I have an CSV file with WE8ISO8859P1 encoding generated from Oracle Stored Procedure. Is there any script line […]
RDBMS: Proper way to store data – comma separated variables or in different fields or tables?
Question : Fundamental question that I cannot seem to find an answer on. I have a database that stores line […]
0 rows from the .csv (semi colon) are imported into MySQL Workbench
Question : I am trying to import the .csv below (columns and 3 first records in txt in differenet blockquotes) […]