Re: parsing relname in pg_class

--thanks for emailing:

--not sure what the 'r' in reltype
is, but i'm getting an error. reltype
is defined as oid ... should there be
a letter next to it?

[snip error]

bcn=> select relname from pg_class
bcn-> where reltype = 'r'
bcn-> and relanem not like 'pg%';
ERROR: oidin: error in "r": can't parse "r"

[/snip error]

--not sure, but i think i can use this:

[sql]

select relname from pg_class where
relname not like '%_i'
and relname !~ '[$0-9]'
and relname not like 'pg_%'
order by 1;

[/sql]

--but i have to say, it looks like it's a
bit much (more work than needed) ...
oh well ... at least i'm learning ...

--thanks again!

-X

-----Original Message-----
From: Andrew Sullivan [mailto:andrew(at)libertyrms(dot)info]

On Mon, Apr 01, 2002 at 04:29:34PM -0500, Johnson, Shaunn wrote:
> Howdy:
>
> Running Postgres 7.1.3 on RedHat 7.2 kernel 2.4.7 rel. 10.
>
> I'm writing a perl script where I only want to parse
> out a list of tables from the database I'm connecting
> to.
>
> I'm doing something like this:
>
> [snip]
>
> select relname from pg_class
> where relname not like '%_i%';
>
> [/snip]

What about

SELECT relname FROM pg_class
WHERE reltype = 'r'
AND relname not like 'pg%'

?

[snip]