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

10 votes175 views2 answers
Linux command line import mysql database
SQL
0 vote188 views1 answer
OFFSET consulta mysql
SQL
0 vote171 views1 answer
Google cloud sql postgres url example
SQL
0 vote172 views1 answer
Oracle enable chain
SQL
2 votes169 views1 answer
Update trigger
SQL
3 votes202 views3 answers
Mysql auto increment after delete
SQL
0 vote234 views1 answer
TSQL Find csv file in folder
SQL
0 vote182 views1 answer
Sql query to select records entered in last 24 hours
SQL
4 votes144 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
1 vote191 views1 answer
Oracle turn off constraint
SQL