Convert TSV to PostgreSQL using an API
Use our API to convert your Tab Separated Values data to PostgreSQL
Convert
to
POST
https://dataconverter.io/api/v1/convert/tsv-to-postgresql
After signing up and verifying your email, you will be able to create an API Token in your account settings.
Headers
-
Authorization (required)
Bearer <<YOUR_API_TOKEN_HERE>>
Request Body — (multipart/form-data)
-
file (required)
string <binary>
-
uploadSettings
object
{ "fieldSeparator" : "\t", "allowMultiLineText" : true, "allowQuoteInField" : true, "fieldNamesInFirstRow" : true, "startingQuote" : "\"", "endingQuote" : "\"", "lineSeparators" : "\\n,\\r\\n,\\r", "trimFields" : true, "skipEmptyRows" : false, "charset" : "UTF-8" }
-
downloadSettings
object
{ "tableName" : "bookstore", "pretty" : true, "dropTable" : true, "checkIfDropTableExists" : true, "checkIfTableNotExists" : true, "defaultBigIntegerPrecision" : 20, "defaultBigDecimalPrecision" : 20, "defaultBigDecimalScale" : 5, "useInferredType" : true, "sqlScriptType" : "DDL_AND_DML" }
Request Sample
curl -X POST "https://dataconverter.io/api/v1/convert/tsv-to-postgresql" \
-H "Authorization: Bearer YOUR_TOKEN_HERE" \
-F "file=@data.tsv;type=text/tab-separated-values" \
-F "uploadSettings={\"fieldSeparator\":\"\\t\",\"allowMultiLineText\":true,\"allowQuoteInField\":true,\"fieldNamesInFirstRow\":true,\"startingQuote\":\"\\\"\",\"endingQuote\":\"\\\"\",\"lineSeparators\":\"\\\\n,\\\\r\\\\n,\\\\r\",\"trimFields\":true,\"skipEmptyRows\":false,\"charset\":\"UTF-8\"};type=application/json" \
-F "downloadSettings={\"tableName\":\"bookstore\",\"pretty\":true,\"dropTable\":true,\"checkIfDropTableExists\":true,\"checkIfTableNotExists\":true,\"defaultBigIntegerPrecision\":20,\"defaultBigDecimalPrecision\":20,\"defaultBigDecimalScale\":5,\"useInferredType\":true,\"sqlScriptType\":\"DDL_AND_DML\"};type=application/json" \
--output converted.sql