What is the database table for pages?

the wp_posts include all post types (post, page, custom post..), and to differentiate between them there is a field called post_type used to specify the name of the current entry whether it’s a page, post or a custom post.

Query below will get list of pages

SELECT * FROM wp_posts where post_type="page";