Select

select 
select count
select distinct

PostgreSQL:

• select * from your_table_name;
• select * from your_db.your_table_name;
• SELECT * FROM pg_stat_activity;
• SELECT version();
• SELECT current user;
• SELECT current database();

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

• 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
  • GRANT SELECT ON ALL TABLES
• ERROR: permission denied for relation your_table
• SELECT can cause synchronous writes on the disk

See also

• SELECT, GRANT SELECT ON, BETWEEN
• SQL, NewSQL, RDMS: 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, .sql