Why are Pages in the Posts table on the database?

  • seethesites

    (@moneytech)


    10 years, 6 months ago

    I was cleaning out old posts, and truncated the wp_posts table. Because there is no wp_pages table for pages I created, I lost all my pages, which are treated as posts. They are NOT posts, they are pages. I wonder why there is not a separate table for just pages, and why, traditionally, WordPress includes them in the wp_posts table?

Viewing 1 replies (of 1 total)
  • catacaustic

    (@catacaustic)

    10 years, 6 months ago

    WordPress includes almost everything in the wp_posts table as just about everything is a post, just with different post types.

    The column that you’d want to check out is post_type. That will tell you what the type is, and you’ll see that there’s a lot more then just post and page in there. If you ever want to delete anythin gagain, make sure that you delete using that column in a WHERE clause so that you don’t loose anything that you don’t want to.

Viewing 1 replies (of 1 total)
  • The topic ‘Why are Pages in the Posts table on the database?’ is closed to new replies.