Is there a way to take a column from csv and just pens through pgadmin4 gash into a table? Or have to write a script?

  • copy ? postgresql.org/docs/9.6/static/sql-copy.html It is not very clear what is and what should be obtained. - Small
  • Yes, not exactly syntax, but take a click on the column in csv, press ctrl + c and then in pgadmin click on the table and just insert this column into it. - t0rick
  • Well, the script let's say it loudly. You can go, for example, to sqlfiddle.com, click on the "Text to DDL" button and, based on your csv data, insert it into the database. In more complex cases, you can do a regular session on regex101.com which will convert the incoming text, again into the set insert - Mike

0