Creating table from csv file

34 views
Skip to first unread message

Alex Steinkamp

unread,
Jun 16, 2014, 11:46:31 AM6/16/14
to web...@googlegroups.com
I am trying to import a csv file into a table in a database. I don't always know the number of columns I will have. This is where I am having my problems. I can't find anywhere how to dynamically add columns to a table. Does anyone have any ideas on how to do this?

Thank you in advance.

Massimo Di Pierro

unread,
Jun 19, 2014, 6:19:38 PM6/19/14
to web...@googlegroups.com
You cannot dynamically add columns. Do you have a superset of possible column names? If so, give a default value to the optional ones.

Manuele Pesenti

unread,
Jun 20, 2014, 8:52:58 AM6/20/14
to web...@googlegroups.com
Il 16/06/14 17:46, Alex Steinkamp ha scritto:
You can even consider to use the json field type to contain your data...
hope it could help.

Cheers

M.
>
> Thank you in advance.

Reply all
Reply to author
Forward
0 new messages