On Thu, 2019-08-22 at 09:01 -0400, Reid Thompson wrote: > On Thu, 2019-08-22 at 08:25 -0400, Reid Thompson wrote: > > On Wed, 2019-08-21 at 17:15 -0400, stan wrote: > > > [EXTERNAL SOURCE] > > > > > > > > > > > > I have a situation where we need to import data, as an interim measure, > > > from spreadsheets. > > > > > > I have read up on \copy and COPY, but I do not see that either of these can > > > use the header from a CSV file to define a new table. Am I missing > > > something? > > > > > > Also downloaded something called pgfutter, which I thought would do this, > > > but have not had any success with this. After I (thought) I had figured out > > > the arguments, it just seams to hag forever. > > > > > > > > > -- > > > "They that would give up essential liberty for temporary safety deserve > > > neither liberty nor safety." > > > -- Benjamin Franklin > > > > > > > > > > https://csvkit.readthedocs.io/en/latest/tutorial/3_power_tools.html#csvsql-and-sql2csv-ultimate-power > > > > csvsql and sql2csv: ultimate power > > ...snip... > > By default, csvsql will generate a create table statement for your data. You can specify what sort of database you are using with the -i flag: > > ...snip... > > > > Example > > https://stackoverflow.com/questions/35243432/how-to-generate-a-schema-from-a-csv-for-a-postgresql-copy > a more detailed example https://archive.is/pFpJi
