How do I extract the contents of a CPT’s custom field for all posts?

I managed to achieve what I wanted by piping wp-cli with xargs and grep, like this:

wp post list --post_type=CPTNAME --field=ID | xargs -n 1 wp post meta list --format=csv | grep -E "^[[:digit:]]*,(CUSTOMFIELD1|CUSTOMFIELD2|...|CUSTOMFIELDN)" >> file.csv

This is, however, extremely slow, taking more than 30 minutes for 10 thousand CPTs.

I think a direct SQL query would be much, much more efficient.

Related Posts:

  1. what is the correct way to compare dates in a WP query_posts meta_query
  2. Advanced search form with filters for custom taxonomies and custom fields
  3. Custom field values deleted when trashing custom post type
  4. How to get all custom fields of any post type
  5. Admin Area Custom Type Search By Meta Fields Without Title & Content
  6. How do I Paginate Search Results for Custom Post Types?
  7. How Can I save multiple records in same meta key?
  8. Detect meta value changes when post is updated (post_updated)
  9. Search everything (posts, pages, tags, cpt, meta)
  10. How to get source of custom meta image?
  11. Displaying Meta Box Image
  12. ACF Upload Image in repeater from front-end with custom form? – add_post_meta()
  13. Formatting custom meta box date from YYYY/MM/DD to a more readable alternative
  14. Create a random unique 6 digit number as custom field for custom post type
  15. how to interconnect custom post types?
  16. List all images from a single post meta value
  17. Populate Custom Fields in a Custom Post Type?
  18. Meta Key Value in current-user-only loop
  19. How to check if user meta field is empty in conditional else statement
  20. How to implement a Google map store locator
  21. Posting to a Custom Post Type from front end – user generated content
  22. Update Post Meta for a logged in user
  23. A better way to add a meta box to custom post types
  24. Two Custom Post Types Many to Many Relationship
  25. get_post_meta not working on publishing
  26. How do I set all of a particular post meta to a value within the custom post type I’m in?
  27. Custom fields (wp_post_meta) vs Custom Table for large amount of data
  28. Importing Data from a Non-WordPress database, into WP
  29. Custom fields for custom post type
  30. Check if post with same meta value exists
  31. Submitting Custom Post Types with custom fields from Front-end form
  32. create custom meta box with default value
  33. delete_post_meta() for whole CPT / multiple posts?
  34. How to get specific post meta by title or id
  35. copy images from custom field to another custom field
  36. How to show custom field on specific custom post type posts only when filled
  37. Cannot obtain custom meta information
  38. How can I output WPAlchemy repeating fields meta values in my page template?
  39. How to call a post’s metadata in shortcode.php?
  40. delete duplicate meta_value with same post_id
  41. Search CPT Title AND Meta
  42. updating one custom meta field only
  43. Add a class to post_class if more than one post shares same meta_value_num
  44. Add a meta field to the list of results for a custom post type
  45. Empty meta-box returns publishdate if no value is set?
  46. Filter search posts by post meta?
  47. Custom fields for post or terms which don’t update on post update
  48. Custom Post Type meta data getting deleted on bulk editing taxonomies
  49. Unable to gather Image URL from Custom Post Type’s; Custom Meta Field
  50. How to keep custom post type related information
  51. How can I add a meta[] to my custom post type and search by term with the Rest API?
  52. Show posts from WP Custom Post Type selected from a field in a metabox
  53. Creating an archive page or simple template to list all values of a custom field of specific post type listing
  54. Where is get_post_meta value located?
  55. Custom meta fields not showing up in WP_Response Object via custom endpoint
  56. How to Disable option of meta field if that option is selected for any other post in custom post type?
  57. Add more custom fields when creating a new custom post type
  58. Delete custom post type metadata without deleting the post in admin area
  59. How can I get the $key / $value pairs of custom fields that were added via 3rd party plugins or themes?
  60. How to add post reference field to a plugin?
  61. Advanced search form with filters for custom taxonomies and custom fields
  62. Querying meta values within an array
  63. Display a list of posts whose meta field values are equal to the ID of the post being viewed?
  64. Check for custom field value in different post type than current one and do something
  65. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  66. Using custom field content as expression in IF statement [closed]
  67. Meta Query Not Returning Output Despite Having Matching Values
  68. How to create a custom post type with additional fields?
  69. Callback to custom field is not working in WordPress REST API
  70. Meta Query Filtering not working on Custom Meta Box using Radio Buttons
  71. Including metaboxes from custom post types in global search — continued
  72. post meta parameter in post custom-post-type endpoint with restapi
  73. ACF From & To Date Validations
  74. Query Multiple Custom Posts by Custom Fields
  75. Show image gallery from a custom field
  76. Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
  77. Dynamic dropdown select values depending on other custom field value
  78. How to render a custom post type template with custom fields using shortcode
  79. Disable saving posts as draft (make all posts mandatory regardless of the post status)
  80. Grouping metadatas into one
  81. Tracking changes in admin-page so user gets warning when leaving the page
  82. filter custom post in rest api with custom function
  83. Get Posts by multiple custom fields is not working
  84. Woocommerce custom field search in custom post type [closed]
  85. Update postmeta Parent when post_status child change
  86. Metabox not show in categories custom post type cmb2
  87. Add custom field in comments form
  88. WordPress request fiter order by related post’s post_title
  89. Custom Fields for Custom Post [closed]
  90. Order Custom Post Type by Custom Field Value
  91. Filter custom post types by a field value
  92. Displaying All Posts of a Custom Post Type in WordPress Multisite Backend
  93. Repeatable Fields Metabox with Textarea (or wp_editor)
  94. How to use TinyMCE Editor for one of my custom post meta field?
  95. Custom REST endpoints for a custom post type with custom fields
  96. How to Create a WordPress Plugin With Custom Post Type/Custom Field Features?
  97. Hierarchy and access control for Custom Post Types (CPT)
  98. Update database from Quick Edit according to Checkbox state of Custom Post Type
  99. How to integrate a form (Ninja Form or Contact Form 7) with Custom Post Types?
  100. Storing a many to many post type relationship in post meta and keeping SQL ability for Joins