Thread: tables in public

> Hello.
>
> Postgres automatically included some tables in my public domain:
> pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser,

I beleive these are from tsearch2.

> spatial_ref_sys.

And this is postgis.

> I suppose it's because I switched on  all additional options
> during initdb...

Yes (this is win32 MSI installer, right?)


> My question regarding those tables is wheter I can delete
> them safely from public ?

Yes, unless you plan to use any of the functionality of those modules.

//Magnus

Could you, please, give me short description of  functionalities of those
modules?
I don't know whether I need it, because I don't know what is the purpose of
those tables...

----- Original Message -----
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>;
<pgsql-general@postgresql.org>
Sent: Saturday, August 06, 2005 9:28 PM
Subject: RE: [GENERAL] tables in public


> Hello.
>
> Postgres automatically included some tables in my public domain:
> pg_ts_cfg, pg_ts_cfgmap,pg_ts_dict, pg_ts_parser,

I beleive these are from tsearch2.

> spatial_ref_sys.

And this is postgis.

> I suppose it's because I switched on  all additional options
> during initdb...

Yes (this is win32 MSI installer, right?)


> My question regarding those tables is wheter I can delete
> them safely from public ?

Yes, unless you plan to use any of the functionality of those modules.

//Magnus

> Could you, please, give me short description of
> functionalities of those modules?

tsearch2 is full text indexing. postgis is geographical functionality.

//Magnus

OK.thanks...I suppose I don't need it.

----- Original Message -----
From: "Magnus Hagander" <mha@sollentuna.net>
To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr>;
<pgsql-general@postgresql.org>
Sent: Saturday, August 06, 2005 9:55 PM
Subject: RE: [GENERAL] tables in public


> Could you, please, give me short description of
> functionalities of those modules?

tsearch2 is full text indexing. postgis is geographical functionality.

//Magnus