Selecting Data

To read rows from a table, use select. The * wildcard retrieves every column:

select * from main.users;

You should see all three users that have been inserted for you. If you only need specific fields, list them by name instead of *:

select name from main.users;

This returns only the name column. You can list multiple columns separated by commas:

select id, name from main.users;

Which in this case gives you the same result as *, since main.User only has those two fields.