Get custom fields value from all posts WordPress custom question using get_results and prepare method.

global $wpdb;
$result = $wpdb->get_results($wpdb->prepare(
"SELECT meta_value FROM wp_postmeta WHERE meta_key = %s", 'post_meta'
), ARRAY_A);