Re: table size and storage location

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
Cc: chuckee <mi6(at)orcon(dot)net(dot)nz>, pgsql-general(at)postgresql(dot)org
Subject: Re: table size and storage location
Date: 2008-03-26 02:09:58
Message-ID: 10172.1206497398@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com> writes:
> On 25/03/2008, chuckee <mi6(at)orcon(dot)net(dot)nz> wrote:
>> Thanks but I still get the error 'ERROR: relation "capture" does not exist'
>> when trying these two alternative functions you mention above. There is
>> definitely a table called 'capture' in my database!

> Are you sure you're connected to the right database
> when running that?

Case-sensitivity is the other standard gotcha ... maybe the table is
really named "Capture" or something like that?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2008-03-26 02:32:42 Re: OLEDB vs ODBC to access postgres
Previous Message paul rivers 2008-03-26 01:53:28 Re: table size and storage location