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

4 votes198 views1 answer
Force drop all tables postgres
SQL
2 votes235 views1 answer
Python sql
SQL
0 vote195 views1 answer
Sqlalchemy sequence postgresql
SQL
1 vote187 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
19 votes197 views2 answers
Mysql tinyint max value
SQL
6 votes188 views1 answer
Update left join mysql
SQL
0 vote207 views1 answer
Sql output select
SQL
0 vote204 views1 answer
Create a table from one field of another table
SQL
0 vote197 views1 answer
Output table plsql
SQL
1 vote213 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL