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

20 votes341 views6 answers
Mysql reset auto increment
SQL
5 votes348 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
2 votes328 views2 answers
Mysql user access to database
SQL
0 vote318 views1 answer
Query on date sqlite flutter
SQL
1 vote317 views1 answer
Oracle aleter trigger ora-01031
SQL
14 votes320 views1 answer
Excel is not a database
SQL
5 votes378 views3 answers
Sql limit offset
SQL
4 votes327 views2 answers
How to insert ip address in mysql using php
SQL
8 votes354 views2 answers
Update sql server from another table
SQL
0 vote340 views1 answer
Postgres grep entire database
SQL