Re:

From: "D(dot) Duccini" <duccini(at)backpack(dot)com>
To: Sujith C S <sujithcs(at)ddsl(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re:
Date: 2000-10-27 18:09:58
Message-ID: Pine.GSO.4.03.10010271309210.25560-100000@ra.bpsi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


simply, you can

select tablename from pg_tables;

but that gives you all of them, including the system tables

-duck

On Fri, 27 Oct 2000, Sujith C S wrote:

> Sir.
> How to list the table names in SQL server using a query...
> Like Select * from tab in Oracle...
> Plz help.
>

-----------------------------------------------------------------------------
david(at)backpack(dot)com BackPack Software, Inc. www.backpack.com
+1 651.645.7550 voice "Life is an Adventure.
+1 651.645.9798 fax Don't forget your BackPack!"
-----------------------------------------------------------------------------

In response to

  • at 2000-10-27 13:02:15 from Sujith C S

Browse pgsql-novice by date

  From Date Subject
Next Message S.A.Pamungkas 2000-10-28 10:48:05 error make all
Previous Message Sujith C S 2000-10-27 13:02:15