sqlalchemy query without column [duplicate]

Question

In postgresql we can get total row count without sending column.

select count(*) from mytable; -- returns count (total number of rows)

Is there any way to so similar thing in sqlalchemy without doing raw query

session.execute('select count(*) from mytable;')

That query does not select the count: sqlfiddle.com/#!17/60d91/1 and even throws an error in older postgresql versions — juergen d
– juergen d, Commented Aug 30, 2019 at 6:36
Possible dublicate of stackoverflow.com/questions/12941416/… — Scott
– Scott, Commented Aug 30, 2019 at 6:40

Laurenz Albe · Accepted Answer · 2019-08-30 06:38:15Z

1

That's a bad idea, because

lots of empty rows consume more space than a single one with a bigint
such a query does not conform to the SQL standard, so you lose portability for no good reason

Go with

SELECT count(*) FROM mytable;

answered Aug 30, 2019 at 6:38

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1