Related

Select Data

mysql

Query data from tables

Build Command Lines

linux

Build and execute command lines from standard input

Restore Database

psql

Restore a PostgreSQL database from a backup file

psql/execute-query

Execute SQL Query

Run a SQL query from the terminal

query
execution

Command

psql -c "SELECT * FROM tablename;"

Explanation

Executes a given SQL query directly from the command line.

Examples

Query all rows from users table

psql -c "SELECT * FROM users;"

More

Nested Query Example

graphql

Query users with nested posts

Use Fragments

graphql

Query with reusable fragments

Aliases Example

graphql

Rename query results using aliases