Have fun This kind of “playing around” or “self learning” in the DB is not the topic of support at meta, so. If you are good at SQL, it’s a piece-of-cake.Įveryone here will recommend you play around on a staging setup (where if you break things you can just rebuild and start over) and have fun!ĭon’t play around on a production system with real users, until you are very comfortable with the tech (maybe have mastered the basics at least) and always make full backups first Im trying to create a scheduled task with the option 'run only when user is logged in' but I dont know how to do it with powershell. If you wish (for example, and not an efficient example at that) to examine the first 10 users (ordered by id descending, only 10) you can just: SELECT * FROM users ORDER BY id desc LIMIT 10 Īnyway, you get the idea. If you find a table of interest, say the users table, you can examine the table structure, like so: \d users If you want to list all tables with the word “setting”, then you can: \dt *setting* Then, if you want to list all the tables in the DB, you can: \dt When your organization is in read-only mode, Salesforce Classic desktop and mobile browser users will see a banner at the top of their browser window. Laxness modes designed to help ensure amateur Composr developers write or port code without knowing too much about database portability (MySQL is the only. Your app is currently in read-only mode because you are running from a package file. But in general programs don't do that, so that defaulttransactionreadonly is sufficient to deny them the ability to write. Now, if all was running properly, you are in the DB as the discourse user connected to the discourse DB ready to issue PostgreSQL and SQL commands. While in read-only mode, a session can always issue SET defaulttransactionreadonly to OFF to get out of this mode, or start any individual transaction with BEGIN read write. Can you please explain this process, I am a newbie on containers and would love to start playing with my postgres DB instead of having the container be a big black box to meĪssuming you are in OOTB single container mode in the standard supported setup: cd /var/discourse
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |