A
A
Alf1622014-04-10 10:09:49
PostgreSQL
Alf162, 2014-04-10 10:09:49

Schema selection in postgresql

Tell me how you can select a scheme immediately when connecting to the database. when there was one public schema, there were no problems. Now there are a bunch of schemas, and if you add the schema name to the table name in each query, it will not be very cool. Therefore, I want to choose a scheme once and work with it.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alf162, 2014-04-10
@Alf162

The problem is solved:
SET search_path TO schema_name

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question