Can't append selected data in Base

I’m trying to to append data from Calc to a postgres instance using Base.
The connection is successful, i can see the tables, pasting the data into the desired table correctly assigns the columns yet upon clicking “Create” nothing happens.
The window closes without any errors, no data is inserted.

I searched through the forums but haven’t found any information, help appreciated!

image

Pleas show the system and the version of LO you use? Also: Which database connection to PostgreSQL is working.
You have attached the first screenshot of the wizard, for copying content to tables. Please show what happens if you run to the whole wizard by “Next>”.

Turns out turning off the “use first lines as column names” fixed it, i wasted an hour on this :person_facepalming:
Have a great weekend mate

1 Like