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?
Hi @Jethro! Did you receive any warning messages in your AppSheet editor after you regenerated your tables data?
@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.
@Jethro Ah! That makes sense. Glad to hear you were able to resolve this.
1 Like