# Given a PostgresSQL.jl connection string, what's the easiest way to create a table in the database by copying a dataframe into it?
**URL:** https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131
**Category:** Data
**Created:** [September 14, 2021, 7:02am UTC](https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131 "2021-09-14T07:02:29Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@xiaodai](https://discourse.julialang.org/u/xiaodai)
#### Post date: [September 14, 2021, 7:02am UTC](https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131/1 "2021-09-14T07:02:29Z")
I have tried
```julia
using ODBC
conn = ODBC.Connection("Driver={PostgreSQL Unicode(x64)};Server=db.bit.io;Port=5432;Database=bitdotio;Uid=xxx;Pwd=xxx;")
tbl = DataFrame(a=1:3)
ODBC.load(tbl, conn, "tbl1"; append=false)
```
But it gives error
```julia
ERROR: HY000: LOG: Error occurred when processing query: relation ""."tbl1" does not exist (error ID: e6555b01-5bf7-4801-9941-3cbc2067d6d7);
```
The LibPQ insert statement might work but I am trying to upload a largish file so I want to make it as efficient as possible.
---
### Author:  [@lungben](https://discourse.julialang.org/u/lungben)
#### Post date: [September 14, 2021, 7:47am UTC](https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131/2 "2021-09-14T07:47:56Z")
You can use [https://github.com/lungben/TableIO.jl](https://github.com/lungben/TableIO.jl) to upload large data amounts to Postgres via LibPQ.jl.
It uses internally the Postgres COPY function to upload the data in CSV format (using CSV.jl), which is much more efficient than uploading with an SQL Insert, see [https://github.com/lungben/TableIO.jl/blob/master/src/postgresql.jl#L20](https://github.com/lungben/TableIO.jl/blob/master/src/postgresql.jl#L20).
---
### Author:  [@drvi](https://discourse.julialang.org/u/drvi)
#### Post date: [September 14, 2021, 7:57am UTC](https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131/3 "2021-09-14T07:57:59Z")
I agree, you want to use COPY FROM stdin. This closed PR [https://github.com/invenia/LibPQ.jl/pull/172](https://github.com/invenia/LibPQ.jl/pull/172) contains some examples. When providing a CSV, be sure to quote the fields accordingly.
Edit: There is also an example in the docs [Home · LibPQ.jl](https://invenia.github.io/LibPQ.jl/dev/#COPY)
---
### Author:  [@xiaodai](https://discourse.julialang.org/u/xiaodai)
#### Post date: [September 14, 2021, 10:25am UTC](https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131/4 "2021-09-14T10:25:43Z")
> [@lungben](#):
>
> It uses internally the Postgres COPY function to upload the data in CSV format (using CSV.jl), which is much more efficient than uploading with an SQL Insert, see [TableIO.jl/postgresql.jl at master · lungben/TableIO.jl · GitHub](https://github.com/lungben/TableIO.jl/blob/master/src/postgresql.jl#L20).
Doesn’t work it says “tablename must only contain alphanumeric characters and underscores” which is not true for Postgres Tables
After fixing that function I get an error say the table doesn’t exist. I was looking for something that would create the table for me if it doesn’t exist. I guess i have to write some code now.
---
### Author:  [@lungben](https://discourse.julialang.org/u/lungben)
#### Post date: [September 14, 2021, 10:45am UTC](https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131/5 "2021-09-14T10:45:15Z")
The CSV upload does not create a table, you need to do this beforehand.
Usually, for a “persistent” database like Postgres you have a fixed schema which you use to create your tables and you populate your data afterwards. Thus creating a new table at the same time as filling it is not a very common use case.
---
### Author:  [@xiaodai](https://discourse.julialang.org/u/xiaodai)
#### Post date: [September 14, 2021, 10:47am UTC](https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131/6 "2021-09-14T10:47:35Z")
no worries. I wrote a function to create the table.
---
### Author:  [@quinnj](https://discourse.julialang.org/u/quinnj)
#### Post date: [September 14, 2021, 3:43pm UTC](https://discourse.julialang.org/t/given-a-postgressql-jl-connection-string-whats-the-easiest-way-to-create-a-table-in-the-database-by-copying-a-dataframe-into-it/68131/7 "2021-09-14T15:43:56Z")
Just for context; ODBC.jl doesn’t automatically create a table for you since it’s just a “middleware” and there isn’t a mechanism in the ODBC spec to generically create a table in any supporting database.