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

1 vote382 views1 answer
Base64 encode sql server
SQL
1 vote350 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
3 votes350 views2 answers
Host is not allowed to connect to this mysql server
SQL
6 votes386 views3 answers
Psql show columns of table
SQL
1 vote365 views1 answer
Postgresql escape single quote
SQL
1 vote373 views1 answer
Mysql search like order by best match
SQL
24 votes384 views4 answers
Postgres delete database
SQL
5 votes338 views1 answer
How to check port number for postgresql
SQL
0 vote344 views1 answer
Mysql two joins
SQL
0 vote359 views1 answer
Longtext sql
SQL