select

From wikieduonline
Revision as of 13:47, 8 November 2022 by Ant (talk | contribs)
Jump to navigation Jump to search


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;


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


Related terms

See also

Advertising: