Is there a way to create a table in Postgres by reading in a CSV and using the headers as column headers?
The only thing I've come across is copying table contents but that is only after you create the table.
2
-
CSVs do not usually have column specifications, so how do you expect Postgres to infer the table creation instructions?David– David2020-04-06 19:42:26 +00:00Commented Apr 6, 2020 at 19:42
-
1Does this answer your question? Can I automatically create a table in PostgreSQL from a csv file with headers?David– David2020-04-06 19:45:12 +00:00Commented Apr 6, 2020 at 19:45
Add a comment
|