Solved: Cant regenerate - Postgres (solved) - Page 2

Jethro · 10-23-2019 03:59 AM

I have a table in Postgres and all works well. However, I had to add one additional column. When I regenerate the columns, the new one does not appear. How can I get my new column in my Postgres table to “regenerate” into my appsheet platform?

Jethro

@JCadence Thanks for the reply. Dinh from Appsheet support did a great job helping me sort this out. The issue was as follows (my own mistake).

I manually generated my PostGres table using SQL
This generated nicely in appsheet
I quickly went back to add a column, however this time I used the GUI directly from PgAdmin
I chose the text datatype from the dropdown for my new column, however, in haste I didnt realise I choose text datatype instead
text vs text : text is of course an array

When regenerating in Appsheet it will not show the array datatype.

I changed the datatype. Now regeneration is fine.

View solution in original post