[YSQL] Move out tests from regress directory #29012
Description
Jira Link: DB-18760
Description
The src/postgres/src/test/regress directory accumulated tests in an
unorganized fashion such that certain files have been placed where they
shouldn't be. Move such files to better locations.
Issue Type
kind/enhancement
Warning: Please confirm that this issue does not contain any sensitive information
- I confirm this issue does not contain any sensitive information.