Difference between revisions of "Select"

From wikieduonline
Jump to navigation Jump to search
Line 20: Line 20:
 
* <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
 
* <code>[[jq]] '.[] | [[select]](.color=="blue")' your_json_file.json</code>
  
  [[ERROR: permission denied for relation]] your_tables
+
  [[ERROR: permission denied for relation]] your_table
  
 
== Related terms ==
 
== Related terms ==

Revision as of 11:43, 27 September 2022


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: