Re: [BUGS] BUG #5765: pg_dump fail to find upper case table name

2011-03-10 Thread Bruce Momjian
Kevin Grittner wrote: > Heikki Linnakangas wrote: > > > Manual says (at the bottom of > > http://www.postgresql.org/docs/8.4/static/app-pgdump.html): > > > >> To specify an upper-case or mixed-case name in -t and related > >> switches, you need to double-quote the name; else it will be > >> fo

Re: [BUGS] BUG #5765: pg_dump fail to find upper case table name

2010-11-24 Thread Pavel Golub
Hello, Kevin. You wrote: KG> Heikki Linnakangas wrote: KG> >> Manual says (at the bottom of >> http://www.postgresql.org/docs/8.4/static/app-pgdump.html): >> >>> To specify an upper-case or mixed-case name in -t and related >>> switches, you need to double-quote the name; else it will be >>>

Re: [BUGS] BUG #5765: pg_dump fail to find upper case table name

2010-11-24 Thread Kevin Grittner
Heikki Linnakangas wrote: > Manual says (at the bottom of > http://www.postgresql.org/docs/8.4/static/app-pgdump.html): > >> To specify an upper-case or mixed-case name in -t and related >> switches, you need to double-quote the name; else it will be >> folded to lower case (see Patterns). But

Re: [BUGS] BUG #5765: pg_dump fail to find upper case table name

2010-11-24 Thread Kevin Grittner
"Cristiano" wrote: > Operating system: Linux > Description: pg_dump fail to find upper case table name > --table public."streetTypes" Linux is eating the quotes. Try: --table public.'"streetTypes"' While a bit confusing, this is not a bug in the code. Perhaps the documentation should s

Re: [BUGS] BUG #5765: pg_dump fail to find upper case table name

2010-11-24 Thread Heikki Linnakangas
On 24.11.2010 13:34, Cristiano wrote: pg_dump --host www --port 5432 --username postgres --format plain --column-inserts --verbose --file "streetTypes.sql" --table public."streetTypes" "geocoding-dev" Password: pg_dump: No matching tables were found pg_dump: *** aborted because of error Test cas

[BUGS] BUG #5765: pg_dump fail to find upper case table name

2010-11-24 Thread Cristiano
The following bug has been logged online: Bug reference: 5765 Logged by: Cristiano Email address: sumar...@gmail.com PostgreSQL version: 8.4.4 Operating system: Linux Description:pg_dump fail to find upper case table name Details: The following command line did not