The Greek letter π in their name refers to p orbitals. The orbital symmetry of the pi bond looks the same as the p orbital when seen down the bond axis. P orbitals usually have this sort of bonding. D orbitals are also assumed to use pi bonding but this is not necessarily what happens in reality. The idea of bonding d orbitals fits in with the theory of hypervalence.