Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 42264476AB1 for ; Tue, 7 Jan 2003 06:03:04 -0500 (EST) Received: from mailhub1.sghms.ac.uk (firewall.sghms.ac.uk [194.82.50.2]) by postgresql.org (Postfix) with ESMTP id 9F703476AAD for ; Tue, 7 Jan 2003 06:03:03 -0500 (EST) Received: from [194.82.51.24] (helo=imail) by mailhub1.sghms.ac.uk with esmtp (Exim 4.05) id 18VrVy-0005cY-00; Tue, 07 Jan 2003 11:03:22 +0000 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.1 HotFix 0.7 (built May 7 2002)) with ESMTPA id <0H8C00I7EC0VKU@imail.sghms.ac.uk>; Tue, 07 Jan 2003 11:02:55 +0000 (GMT) Date: Tue, 07 Jan 2003 11:03:15 +0000 From: Adam Witney In-reply-to: <3E1AB00F.1040207@infophil.com> To: alviN , pgsql-sql Message-id: MIME-version: 1.0 User-Agent: Microsoft-Entourage/10.1.1.2418 Subject: Re: SQL list table names Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT X-Spam-Status: No, hits=-101.8 required=5.7 tests=IN_REP_TO,QUOTED_EMAIL_TEXT,SPAM_PHRASE_00_01, SUBJECT_IS_LIST,USER_AGENT,USER_AGENT_ENTOURAGE, USER_IN_WHITELIST version=2.43 X-Spam-Level: X-MailScanner-MH1: Found to be clean X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/50 X-Sequence-Number: 10915 If you start psql like so psql -E Then all the SQL behind the \d type commands is displayed for you. adam > is it possible to execute an sql query to be able to list the tables's > names? > well, you can do it on psql using \dt. but im talking about the SQL > statement, because i want to execute that query from a script. > > thanks. > > > > alviN > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.