I want to run a schema-specified query without writing the schema name in the query.

Asked 2 years ago, Updated 2 years ago, 127 views

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

sql postgresql

2022-09-30 21:45

1 Answers

Is it possible to set the search path for the schema in question?

https://kanamelogic.com/20180427/search_path/


2022-09-30 21:45

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.