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 vote205 views1 answer
Oracle check table space
SQL
7 votes199 views3 answers
Sql server reset auto increment
SQL
18 votes270 views3 answers
Get the list of all tables in sql server
SQL
2 votes180 views3 answers
Postgres remove foreign key constraint
SQL
0 vote195 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote261 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote198 views2 answers
Plsql function that return a table
SQL
1 vote214 views1 answer
Customer using hdfc bank sql query
SQL
0 vote189 views1 answer
Select password from user mysql
SQL
1 vote203 views1 answer
Create new table in SQL from old table with data
SQL