--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@libertyrms.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]