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

Try API Free

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,
  "fieldNamesInFirstRow" : true,
  "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,\"fieldNamesInFirstRow\":true,\"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

Show All APIs