Postgresql – the differences between to and = in set search_path

postgresqlschema

I have different schemas in my database like,

public

Hotel_Management

Hospital_Management

My default schema is Public. So I try to change from default schema to another schema.
I know how to change the schema from one to another.

set search_path to Hotel_Management;

But my doubt is, What is the real difference between to and = in set search_path?.

For example:

Set search_path to Hotel_Management;

and

Set search_path = Hotel_Management;

Thanks in Advance…

Best Answer

There is no difference.

If you look at the manual one is the alternative to the other. { TO | = } means either TO or =

The meaning of that is explained at the start of the manual

and vertical lines | indicate that you must choose one alternative

Related Question