SELECT column name FROM table name
Was executed on Dataclips in Heroku, and I was able to check the contents of the database.
SELECT "name" FROM users
With the above command, only the specified ones will be acquired, but to acquire all the data contained in the table at once,
SELECT * FROM users
By doing, you can get all the data contained in the users table at once.
Recommended Posts