Select

PostgreSQL select:

• select * from your_table_name;

• select * from your_db.your_table_name;

SELECT * FROM your_table_name;
ERROR: permission denied for table your_table_name

SELECT version();
SELECT current user;

• select current_setting('block_size');

• MySQL: select user FROM mysql.user;

• jq '.[] | select(.color=="blue")' your_json_file.json

Related terms

• MongoDB: db.YOUR_COLLETION_NAME.find ()
• select count
• select distinct
• GRANT SELECT
• ERROR: permission denied for relation your_table

See also

• SQL, NewSQL: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint