Re: Multiple table entries?

Greg Stark wrote:
> On Sun, Aug 23, 2009 at 4:06 AM, Jeff Ross<jross@wykids.org> wrote:
>
>> Greg Stark wrote:
>>
>
>
>>> Actually, I wonder if this isn't more likely to show the problem -- it
>>> would explain why *all* your tables are showing up with duplicates
>>> rather than just one.
>>>
>>> select xmin,xmax,ctid,oid,* from pg_namespace
>>>
>> http://openvistas.net/pg_namespace_query.html
>>
>
> Yeah, that's a problem. Would you be able to load the pageinspect
> contrib module and run a query?
>
> select (h).* from (select
> heap_page_items(get_raw_page('pg_namespace',0)) as h from p) as x;
>
>
>
>

I had to modify your query slightly to make it run--hope I got what you
are after!

select (h).* from (select
heap_page_items(get_raw_page('pg_namespace',0)) as h) as x;

http://www.openvistas.net/pageinspect.html

Thanks,

Jeff