# Help someone who has experience with SQL tables (Postgresql), "set column value" in the users table is not working

**URL:** <https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726>\
**Category:** Ask for Help\
**Tags:** sql\
**Created:** [April 19, 2024, 12:40pm UTC](https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726 "2024-04-19T12:40:57Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bilol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bilol/32/61455_2.png) [@Bilol](https://community.glideapps.com/u/Bilol)\
**Post date:** [April 19, 2024, 12:40pm UTC](https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726/1 "2024-04-19T12:40:57Z")

</div>

I replaced the users table from the Glide table with a SQL table. and now the “set column value” is not working  
Do you think it was worth changing the user table to SQL table?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 19, 2024, 12:52pm UTC](https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726/2 "2024-04-19T12:52:25Z")

</div>

Are you sure you didn’t create a Read Only query of your dataset?

> **[PostgreSQL | Glide Docs](https://www.glideapps.com/docs/essentials/data-sources/postgresql#creating-a-read-only-table-with-a-query)**
>
> Read and write data to your PostgreSQL database.

---

<div class="post-metadata">

**Author:** ![Bilol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bilol/32/61455_2.png) [@Bilol](https://community.glideapps.com/u/Bilol)\
**Post date:** [April 19, 2024, 1:55pm UTC](https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726/3 "2024-04-19T13:55:36Z")

</div>

no, before that I manually added lines and entered data, everything works  
but “set column value” doesn’t work(

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 19, 2024, 2:06pm UTC](https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726/4 "2024-04-19T14:06:37Z")

</div>

Did you notice the below in the doc that Jeff linked you to?

 ![CleanShot 2024-04-19 at 22.05.42@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/014f0730cbe185ccb8b4d0d0a03d11e7d8b298ca.png)

---

<div class="post-metadata">

**Author:** ![Bilol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bilol/32/61455_2.png) [@Bilol](https://community.glideapps.com/u/Bilol)\
**Post date:** [April 19, 2024, 2:22pm UTC](https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726/5 "2024-04-19T14:22:51Z")

</div>

yes, I already read this, but I was so hoping there would be a workaround )  
this means I still have to return to the glide table

---

<div class="post-metadata">

**Author:** ![Bilol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bilol/32/61455_2.png) [@Bilol](https://community.glideapps.com/u/Bilol)\
**Post date:** [April 19, 2024, 2:28pm UTC](https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726/6 "2024-04-19T14:28:44Z")

</div>

thanks for the answer

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 19, 2024, 2:41pm UTC](https://community.glideapps.com/t/help-someone-who-has-experience-with-sql-tables-postgresql-set-column-value-in-the-users-table-is-not-working/72726/7 "2024-04-19T14:41:33Z")

</div>

I doubt there is any workaround. The Users table has some special properties in a Glide context. I could imagine that getting it to work as a SQL source table could require some fancy engineering on the Glide side.
