For OS X, there is no field in an Open File Dialog/Sheet where one could paste a URI. Instead, you must download the file and open it (e.g. drag from browser to Desktop, then drag the new file onto the Dock or into your Photoshop document) and then delete the temporary file.