Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6KIRVa45120 for ; Fri, 20 Jul 2001 14:27:31 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: from rmello by fslc.ser.usu.edu with local (Exim 3.22 #1 (Debian)) id 15Nezb-0001Jt-00; Fri, 20 Jul 2001 12:27:15 -0600 Date: Fri, 20 Jul 2001 12:27:15 -0600 From: Roberto Mello To: Magnus Landahl Cc: pgsql-sql@postgresql.org Subject: Re: Get the tables names? Message-ID: <20010720122715.A5060@cc.usu.edu> References: <9j67ra$m1$1@news.tht.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9j67ra$m1$1@news.tht.net> User-Agent: Mutt/1.3.18i X-Archive-Number: 200107/283 X-Sequence-Number: 4086 On Thu, Jul 19, 2001 at 11:04:40AM +0200, 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 NOT LIKE '%pg_%'; The "NOT LIKE" part is to avoid getting the PostgreSQL internal tables in the output. -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer *** TURN OFF YOUR SYSTEM NOW !!! ***