---
title: "Discussion on \"when you have millions of insert statements in a file...\" | Hashnode"
description: "Discussion on \"when you have millions of insert statements in a file...\". Let's say you have a script of one million insert statements with literal values. Of course, this is a bad idea. SQL is a language, not a data exchange format. You should have a file to import with COPY, with all values as CSV for example. Or at leas..."
url: "https://hashnode.com/posts/when-you-have-millions-of-insert-statements-in-a-file/649d91e9880d8d359d066897"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [when you have millions of insert statements in a file...](https://pachot.net/when-you-have-millions-of-insert-statements-in-a-file?utm_source=hashnode&utm_medium=feed)

Let's say you have a script of one million insert statements with literal values. Of course, this is a bad idea. SQL is a language, not a data exchange format. You should have a file to import with COPY, with all values as CSV for example. Or at leas...

Jun 29, 2023 · 6 min read · pachot.net  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#yugabytedb](https://hashnode.com/tag/yugabytedb)
-   [#distributed-database](https://hashnode.com/tag/distributed-database)
-   [#sql](https://hashnode.com/tag/sql)

## Written by

[Franck Pachot](https://hashnode.com/@FranckPachot)

@FranckPachot

  
[View profile](https://hashnode.com/@FranckPachot)

Dev. advocate on YugabyteDB

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
