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 vote241 views1 answer
What is top n result in sql
SQL
0 vote232 views1 answer
Compare if is null sql
SQL
1 vote241 views4 answers
Sequelize migration default value
SQL
0 vote240 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote279 views1 answer
Creating sqeuence in oracle database
SQL
0 vote237 views1 answer
Difference between db.query and db.execute
SQL
1 vote227 views6 answers
In sql
SQL
0 vote228 views1 answer
Mysql create table like
SQL
6 votes241 views2 answers
How to copy data in sql
SQL
0 vote222 views1 answer
Is not null postgresql
SQL