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

0 vote174 views2 answers
How to save result of sqlite query in a table
SQL
11 votes176 views2 answers
Insert current date sql
SQL
1 vote244 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
2 votes160 views1 answer
Sql server find table name
SQL
0 vote223 views1 answer
Using distinct and count together in sql
SQL
0 vote172 views1 answer
What is delimiter in mysql
SQL
2 votes165 views1 answer
Oracle index size calculation
SQL
0 vote181 views1 answer
Drop database using terminal postgres
SQL
0 vote196 views1 answer
Remove mysql from centos 7
SQL
0 vote173 views1 answer
Postgresql create query
SQL