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/
548 rails db:create error: Could not find mysql2-0.5.4 in any of the sources
549 PHP ssh2_scp_send fails to send files as intended
709 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
546 Understanding How to Configure Google API Key
537 Uncaught (inpromise) Error on Electron: An object could not be cloned
© 2024 OneMinuteCode. All rights reserved.