Given schemes $X,Y$ and $Z$ such that $Z$ is a closed subscheme of both $X$ and $Y$ the pushout exists in the category of schemes. So in particular one can glue schemes along a closed point or glue a scheme to itself along a pair of closed points (although one needs to choose a subscheme structure - you would want to take the reduced induced subscheme structure probably). A reference for this (carried out via the category of locally ringed spaces) is given in this paper of Schwede (Corollary 3.9).
In general though one can not necessarily glue more generally - see for instance Example 3.3 in Schwede's paper.