ASK:
Is there a way to do the following without writing the schema name in the query?
Environment:
postgreSQL 9.x
Windows
If possible, I'd like to run it on pgAdmin4
(Because I'm not used to running from cmd)
WHAT YOU WANT TO DO:
①Obtain the same results as in で
<
SELECT*
FROM schemaA.tableA
<
SELECT*
FROM tableA
Is it possible to set the search path for the schema in question?
https://kanamelogic.com/20180427/search_path/
© 2024 OneMinuteCode. All rights reserved.