How to count with except in psql

# In case you want to count the no. of rows in your psql query which is using except

# let's say this is your original query

SELECT id from table1 except select id from table2;

# to get count do this
select count(*) from (SELECT id from table1 except select id from table2) temp;

Similar codes

5 votes181 views4 answers
Upload database mysql command line
SQL
0 vote168 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote167 views1 answer
Including parameters in OPENQUERY
SQL
0 vote171 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote166 views2 answers
Sql count number of rows after group by
SQL
0 vote173 views1 answer
Get foreign table names mysql
SQL
0 vote154 views1 answer
Print orcale
SQL
0 vote184 views1 answer
Check if string is a number sql
SQL
5 votes171 views1 answer
How to use rank function in sql
SQL
0 vote126 views1 answer
Import sql file in mysql linux
SQL