It is in between the first reading and second reading.
The psalm for the Mass on Corpus Christi (Sunday, 2 June 2013) is Psalm 110, verses 1-4 in the new numbering (it would be psalm 109 in the Vulgate).
On all Sundays and Solemnities (Christmas, All Saints, Immaculate Conception, Assumption, etc.) there are three (well, four if you count the psalm), usually an Old Testament reading, a psalm, a New Testament reading, and the Gospel. Weekday Masses only have one reading, the psalm, and the Gospel, there is no second reading on a non-solemnity.
Immediately after the first scripture reading
Psalm 9 is a lament Psalm.
Psalm 23 is the most popular Psalm.
The most quated psalm is psalm 23.
Psalm 91 has 16 verses and Psalm 100 has 5 verses. Psalm 91 is about how God protects us and Psalm 100 is about singing praises to the Lord.
99 - Psalm 1 - Psalm 99
The Psalm 92 is written when captive in Babylon.
Psalm 100 is known as a Psalm of joy and reverence. It is often called the "Psalm of Thanksgiving" because it focuses on praising God with joy and thankfulness for His steadfast love and faithfulness.
Psalm 14 focuses on the way of the wicked. Psalm 15 focuses on the way of the righteous. It is a Psalm showing how a righteous person should live.
Funerals. Just look at any prayer cards offered by Funeral homes- popularily and somewhat erroneously called Mass Cards. a mass card is a promise an actual Mass will be offered for the deceased. a Prayer card merely has the necessary obituary type facts and dates. and usually the 23rd Psalm or some other appropriate prayer.Prayer cards are wallet sized, mass cards are much larger, usually.