From: Magnus Landahl <magnus.landahl@datessa.se>
To: pgsql-sql@postgresql.org
Subject: Re: Get the tables names?
Date: Fri, 20 Jul 2001 23:14:40 +0200
Message-ID: <9ja701$n7l$1@news.tht.net> (raw)
References: <Pine.LNX.4.21.0107201642270.3206-100000@olympus.scw.org>
Hi Everybody!!
Well I tried this (below) and it workt perfectly. Thanks a lot for ALL
answers to my question!
>select tablename from pg_tables where tablename not like 'pg_%';
Kind regards,
Magnus Landahl
"Joel Burton" <jburton@scw.org> skrev i meddelandet
news:Pine.LNX.4.21.0107201642270.3206-100000@olympus.scw.org...
> On Fri, 20 Jul 2001, Dado Feigenblatt wrote:
>
> > Magnus Landahl wrote:
> >
> > >Hi everybody!
> > >
> > >Is it possible to get the names of all tables in the database with a
sql
> > >query??
> > >
> > >Best regards,
> > >
> > >Magnus
> > >
> > >
> > >
> > >---------------------------(end of
broadcast)---------------------------
> > >TIP 3: if posting/reading through Usenet, please send an appropriate
> > >subscribe-nomail command to majordomo@postgresql.org so that your
> > >message can get through to the mailing list cleanly
> > >
> > >
> > >
> > Not sure if this is the best way, but it works.
> > SELECT relname , relowner from pg_class where relkind = 'r';
> >
> > The only thing is that this includes system tables.
> > So if you want to strip those you need to
> > SELECT relname , relowner FROM pg_class WHERE relkind = 'r' and
> > relowner != 26;
> >
> > Is user postgres always 26? Maybe you have to find that out first.
>
> system tables all ~ '^pg', which is probably a better check than
> user=postgresql.
>
>
> hth,
> --
> Joel Burton <jburton@scw.org>
> Director of Information Systems, Support Center of Washington
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: magnus.landahl@datessa.se
Subject: Re: Get the tables names?
In-Reply-To: <9ja701$n7l$1@news.tht.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox