select

From wikieduonline
Revision as of 11:43, 27 September 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
ERROR: permission denied for relation your_table

Related terms

See also

Advertising: