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 votes270 views3 answers
Day of week postgresql
SQL
5 votes282 views1 answer
Sysdate in oracle sql
SQL
0 vote261 views1 answer
Pip install mysqlclient error
SQL
12 votes280 views10 answers
Google
SQL
3 votes260 views1 answer
Oracle undo tablespace list by user
SQL
0 vote954 views1 answer
Mysql custom sort order
SQL
0 vote275 views1 answer
Import excel to sql
SQL
5 votes298 views2 answers
Postgresql add not null constraint
SQL
0 vote249 views1 answer
Month mysql
SQL
1 vote275 views1 answer
Postgres convert date to string
SQL