Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6KCXna68879 for ; Fri, 20 Jul 2001 08:33:49 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6JN1Ea35933 for ; Thu, 19 Jul 2001 19:01:14 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f6JMpsM08619 for pgsql-sql@postgresql.org; Thu, 19 Jul 2001 18:51:54 -0400 (EDT) (envelope-from news) From: Nils Zonneveld X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Get the tables names? Date: Fri, 20 Jul 2001 00:51:12 +0200 Organization: Nilsies little old network Lines: 23 Message-ID: <3B576455.4F927009@mbit.nl> References: <9j67ra$m1$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@cistron.nl X-Mailer: Mozilla 4.75 (Macintosh; U; PPC) X-Accept-Language: nl,en To: pgsql-sql@postgresql.org X-Archive-Number: 200107/271 X-Sequence-Number: 4068 Magnus Landahl wrote: > > Hi everybody! > > Is it possible to get the names of all tables in the database with a sql > query?? > select tablename from pg_tables where tablename !~ '^pg_'; or more SQL92 like: select tablename from pg_tables where tablename not like 'pg_%'; Kind regards, Nils Zonneveld -- Alles van waarde is weerloos Lucebert