Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Restore search_path to default value in postgresql

Tags:

postgresql

Anyone knows how to restore search_path to default value in postgresql? I changed its value, but now I want to use the default value again. Any help is appreciated.

cheng

like image 830
cheng Avatar asked Oct 18 '25 20:10

cheng


1 Answers

Try with this:

SET search_path TO DEFAULT ;
like image 91
Diego Schulz Avatar answered Oct 21 '25 11:10

Diego Schulz