[SQL] retrieve the tables names based on the owner

[Antonis Antoniou]

Hi guys,
How can I retrieve (with a query) from a database, only the table names 
based on the owner name?

Many Thanks
Antonis
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Problem with stored procedure

[Antonis Antoniou]

Patrice OLIVER wrote:
Hello,
In this example, I use 2 tables :
create table types (
typnum integer primary key,
catcode varchar(2),
typlib varchar(35));
create table uv (
uvnum varchar(5) primary key,
typnum integer,
uvlib varchar(50));
alter table uv
  add constraint fk_uv_type foreign key (typnum)
 references types (typnum)
 on delete restrict on update restrict;
I also use stored procedures :
create function numtype(varchar) returns integer as '
declare
  codetype alias for $1;
  coderet integer;
begin
  select into coderet typnum from types
  where typcode = codetype and catcode = ''UV'';
why not -> select *typenum* into coderet  from types
 where typcode = codetype and catcode = ''UV'';
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
 subscribe-nomail command to [EMAIL PROTECTED] so that your
 message can get through to the mailing list cleanly