How to avoid prefixing every table with schema name while creating new tables ?

Lets assume schema name is my_data. If we want to avoid prefixing every table with my_data while creating a new table, we can set it in the search_path.

Now we can create a new table like this.

By using the above code, courses table will be created in my_data by default.


Discover more from Learners Store

Subscribe to get the latest posts sent to your email.

Leave a comment