Where is custom template file chosen for a post stored in the DB?

It’s in the post meta table (usually wp_postmeta), with the page id in post_id, meta_key with _wp_page_template and meta_value with the template file name.

Related Posts:

  1. SQL Query to Update Admin Email
  2. Two websites one database, administrator not working on second website
  3. Adding prefix to WordPress database tables breaks admin capabilities?
  4. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  5. What is the difference between an ORM and an ODM?
  6. Rename a table in MySQL
  7. How should I tackle –secure-file-priv in MySQL?
  8. Keeping WP database synced across multiple developers using git
  9. Checking if Database Table exists
  10. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  11. Is it possible to define two databases for one installation?
  12. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  13. Connect forms in WP to external database
  14. Hook into $wpdb
  15. Syncing local content with development / staging sites
  16. Export WP database for import using WP-CLI on Vagrant Box
  17. Is it wise to delete post revisions and autosaves from database?
  18. Improve or optimize a very slow query
  19. What is the advantage of separating wp_users and wp_usermeta table?
  20. “MySQL server has gone away” since update to 3.8
  21. WordPress page title repeated in SOME pages
  22. Updating all rows of table with $wpdb
  23. Is $wpdb->prepare escaping to much? How to use it properly?
  24. wp_options table has duplicate rows and primary key / autoincrement has been removed
  25. What is the purpose of storing `siteurl` in database?
  26. How to log database changes during an upgrade?
  27. Using same database for main and subdomain
  28. Emojis getting converted to “?”
  29. Building a Scalable Resiliant WP Setup
  30. Single database for multiple instances
  31. Search and replace special characters (å,ä,ö) for image attachments only in database
  32. Automate dir and DB stack creation with WP-CLI
  33. Moving WP from local server to live, error establishing a db connection
  34. delete post meta from db, even if does not exist?
  35. Is there a way to see history of WordPress database changes?
  36. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  37. Where does the actual data stored by add_post_meta
  38. Exporting table to csv works in the admin but exports HTML data when used on the front end
  39. wp search-replace (not executing)
  40. How to have an external DB read and get data from my wordpress database
  41. Import users from old WP site to new one
  42. Create table from array with prepare
  43. Migrate database between 2 different wordpress version
  44. SSO system between 2 WordPress installs on different servers
  45. Form that sends data to an admin panel and can export it
  46. is $wpdb->get_results() safe enough
  47. Convert user passwords to MD5?
  48. is wordpress stores Role Id in WP database?
  49. Why do database examples sometimes finish with an add_option call?
  50. Does post_meta data need to be unserialzed?
  51. Can’t update WordFence Options, clear data manually
  52. How to backup my site and restore my wordpress site
  53. Is it possible to have more than 1 MySQL database in my WordPress blog?
  54. How to fetch records from database WordPress
  55. AJAX wp-mysql running too slow
  56. Delete/Replace words from X to Y in post content
  57. How get Data form wordpress database as array not stdclass?
  58. cannot connect database
  59. Location of image metadata on my server
  60. How to create more than one new wpdb object?
  61. Multiple WordPress sites installs sharing the same database but with different content and domains
  62. Brandoo WordPress Unable to Update to WordPress 4.2.2
  63. Connecting to wordpress database in my application [closed]
  64. Remote database -> massive response time increase?
  65. Custom Post Type not showing anything added by code anymore?
  66. “sufficient permissions” error for admin after duplicating WP database to new install
  67. Database tables for sports betting integrated in WordPress
  68. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  69. Delete user with only subscriber role
  70. WordPress keeps redirecting to localhost
  71. get value from ‘terms’ table
  72. How to rename custom table name programatically in wordpress?
  73. wp-cli + valet: “Error establishing a database connection”
  74. How to edit custom table data in frontend
  75. pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
  76. generate PDF from member information
  77. Unable to login to a https website via the app after changing from http
  78. mysqli_query(): MySQL server has gone away for Curl Request
  79. Help posting values to DB on submit using $wpdb->query
  80. WP website showing blank page after moving from subdomain to main domain
  81. create a table using user meta custom data
  82. wpdb query to insert images in to post/page gallery
  83. Creating a database in my plugin not working
  84. How to create index (sql) to a meta_key?
  85. WPCLI search and replace in a particlar site dir effect another site-dir
  86. How to create a database table?
  87. get_user_meta and umeta_id
  88. $wpdb not working
  89. Database error after importing WordPress
  90. Send data to database after redirect (and popping out of iframe)
  91. Simple email input store in database
  92. Pulling values from a sepcific row in table
  93. import (migration) user database to wp-users
  94. Create hundreds of users with just ID in phpMyAdmin
  95. What is best for saving lot of extra detail of user?
  96. Insert Extra fields added in the front end registration form to DB
  97. $wpdb->insert not working for last select option
  98. How to create a table [closed]
  99. Upload wordpress from localhost to 000webhost
  100. WP Multisite Users Not Linking