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_table
+
 
  
 
== Related terms ==
 
== Related terms ==
Line 27: Line 27:
 
* <code>[[GRANT SELECT]]</code>
 
* <code>[[GRANT SELECT]]</code>
 
* <code>[[select distinct]]</code>
 
* <code>[[select distinct]]</code>
 +
* <code>[[ERROR: permission denied for relation]] your_table</code>
  
 
== See also ==
 
== See also ==

Revision as of 13:47, 8 November 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


Related terms

See also

Advertising: