Change a value direct in my db with Neon
Hi!
I am looking for how to change a value directly in my Neon db.
I have few users with status and I woulde like to attached to my User Account the value "Admin", because only "ADMIN" can do specific things on y website.
Do you have any idea? I don't find something like that in the documentation.
Thanks you all!
4 Replies
deep-jade•2y ago
I think you’re looking for the Postgres ALTER command, and then the UPDATE command. This isn’t specific to Neon, just Postgres in general 😄
sensitive-blueOP•2y ago
Ho ok! I use neon for a little project but I am not familiar with backend. Do you know how can I update directly in Neon?
deep-jade•2y ago
You can use our SQL Editor to run a query to perform the ALTER/UPDATE queries.
https://neon.tech/docs/get-started-with-neon/query-with-neon-sql-editor
Neon
Query with Neon's SQL Editor - Neon Docs
The Neon SQL Editor allows you to run queries on your Neon databases directly from the Neon Console. In addition, the editor keeps a query history, permits saving queries, and provides Explain and Ana...
sensitive-blueOP•2y ago
Thansk I'll check that 🙂