Postgres Pro
Downloads
Home   >   mailing lists

Thread: contrib/fuzzystrmatch search_path: what does it mean?

contrib/fuzzystrmatch search_path: what does it mean?

From
"Tomi N/A"
Date:
A variable called search_path is set to public at the begining of the
fuzzystrmatch script.
Can anyone tell me what it does?

Cheers,
t.n.a.

Re: contrib/fuzzystrmatch search_path: what does it mean?

From
Martijn van Oosterhout
Date:
On Sat, Dec 09, 2006 at 12:08:08PM +0000, Tomi N/A wrote:
> A variable called search_path is set to public at the begining of the
> fuzzystrmatch script.
> Can anyone tell me what it does?

Check the documentation for the details, but it's basically:

- The list of schemas to look in when given a table name
- The first one is the schema objects are created in by default

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
Attachment

Re: contrib/fuzzystrmatch search_path: what does it mean?

From
"Tomi N/A"
Date:
2006/12/9, Martijn van Oosterhout <kleptog@svana.org>:
> On Sat, Dec 09, 2006 at 12:08:08PM +0000, Tomi N/A wrote:
> > A variable called search_path is set to public at the begining of the
> > fuzzystrmatch script.
> > Can anyone tell me what it does?
>
> Check the documentation for the details, but it's basically:
>
> - The list of schemas to look in when given a table name
> - The first one is the schema objects are created in by default

I would have, but I don't know where the documentation is. The README
in /usr/share/doc/postgresql-x.x.x/contrib doesn't mention it.

Thanks for the prompt reply and the help.
t.n.a.

Re: contrib/fuzzystrmatch search_path: what does it mean?

From
Volkan YAZICI
Date:
On Dec 09 12:52, Tomi N/A wrote:
> 2006/12/9, Martijn van Oosterhout <kleptog@svana.org>:
> >Check the documentation for the details, but it's basically:
>
> I would have, but I don't know where the documentation is. The README
> in /usr/share/doc/postgresql-x.x.x/contrib doesn't mention it.

Google does. Search for 'postgresql "search_path"'.


Regards.

Re: contrib/fuzzystrmatch search_path: what does it mean?

From
Michael Glaesemann
Date:
On Dec 9, 2006, at 21:52 , Tomi N/A wrote:

> I would have, but I don't know where the documentation is. The README
> in /usr/share/doc/postgresql-x.x.x/contrib doesn't mention it.

It's not specific to fuzzymatch (or any other contrib module): it's a
feature of the PostgreSQL server itself.

Michael Glaesemann
grzm seespotcode net