Re: \dF wrt text search - Mailing list pgsql-hackers

Robert Treat wrote:
> Section 12.1.3. Configurations of the developer docs notes that "Fortunately, 
> PostgreSQL comes with predefined configurations for many languages. (psql's 
> \dF  shows all predefined configurations.)"  but alas it doesn't seem to. 
> 
> Welcome to psql 8.3devel, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> postgres=# \dF
> Did not find any relation named "F".
> postgres=# select version();
>                                               version
> ---------------------------------------------------------------------------------------------------
>  PostgreSQL 8.3devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3 
> (Ubuntu 4.0.3-1ubuntu5)
> (1 row)
> 
> Is this information just wrong, or is it floating around on someone's TODO 
> list? If it needs to be I could take a whack at it (though perhaps things are 
> still to in flux to worry about this yet?)

works for me(expect for tab complete support but I already posted a
patch for that):

postgres=# select version();                                                     version

-------------------------------------------------------------------------------------------------------------------PostgreSQL
8.3develon i686-pc-linux-gnu, compiled by GCC gcc (GCC)
 
4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
(1 row)

postgres=# \dF              List of text search configurations  Schema   |    Name    |              Description
------------+------------+---------------------------------------pg_catalog | danish     | Configuration for danish
languagepg_catalog| dutch      | Configuration for dutch languagepg_catalog | english    | Configuration for english
languagepg_catalog| finnish    | Configuration for finnish languagepg_catalog | french     | Configuration for french
languagepg_catalog| german     | Configuration for german languagepg_catalog | hungarian  | Configuration for hungarian
languagepg_catalog| italian    | Configuration for italian languagepg_catalog | norwegian  | Configuration for
norwegianlanguagepg_catalog | portuguese | Configuration for portuguese languagepg_catalog | romanian   | Configuration
forromanian languagepg_catalog | russian    | Configuration for russian languagepg_catalog | simple     | simple
configurationpg_catalog| spanish    | Configuration for spanish languagepg_catalog | swedish    | Configuration for
swedishlanguagepg_catalog | turkish    | Configuration for turkish language
 
(16 rows)


Stefan