I think you need to find the default manager and change the settings for
schema.
Geordie Hobart
GIS Analyst
Refractions Research Ltd.
400-1207 Douglas St.
Victoria,B.C.,
V8W 2E7
[EMAIL PROTECTED]
www.refractions.net
(phone)1-250-383-3022
(fax) 1-250-383-2140
Kevin Neufeld wrote:
> Does anyone know if the FME PostGIS writer can write to a schema other
> than 'public' when writing to a PostGIS enabled PostgreSQL database? The
> reader has a SCHEMA keyword that can fully qualify the name of the table
> being read, however the writer seems to hardcode 'public' in front of
> every table definition when writing to a database.
>
> In Postgres (verisons >7.4), a user can have a schema search_path.
> Consequently, all tables created in Postgres are created in the schema
> (if it exists) identified by the first parameter in the user's
> search_path variable. If the current database does not have the
> specified schema, the next schema in the in the search_path list is
> chosen. The FME PostGIS writer does not seem to look at this variable
> when writing to a database.
>
>
> ----------------
> # sample FME script
> WRITER_TYPE POSTGIS
>
> POSTGIS_HOST host
> POSTGIS_DATASET database
> POSTGIS_PORT 5432
> POSTGIS_USER_NAME user
> # where the user has their search_path defined as: test_schema, public
> and schema 'test_schema' exists
>
> POSTGIS_DEF sample_table \
> ...
>
> ---------------
> In the log...
> 2005-06-17 08:22:57| 2.1| 0.0|INFORM|Testing for the existence of
> table 'public.sample_table'...
> 2005-06-17 08:22:57| 2.1| 0.0|INFORM|Creating table
> 'public.sample_table'...
>
> ----------------
> In this case, a new table should have been created in
> 'test_schema.sample_table'.
>
>
> Cheers,
> Kevin
>
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
