Re: how do I get list of tables?

From: marc sturm <marc_wea(at)yahoo(dot)com>
To: sdeel <sdeel(at)cox(dot)net>, pgsql-novice(at)postgresql(dot)org
Subject: Re: how do I get list of tables?
Date: 2002-08-10 22:04:55
Message-ID: 20020810220455.31596.qmail@web20709.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sam,

Try \? to see all the options in psql,
and \d shows all the tables in your database.
A very little reponse that I hope will help you.

Marc
--- sdeel <sdeel(at)cox(dot)net> wrote:
> Yesterday I created some tables, but I think I must
> have had a typo as I can
> not find them all now. How can I see what tables
> are in my database?
>
> A second question, I did tutorial yesterday opening
> an input file,
> 'basics.source', with \i to get it to single step
> through the file. This
> worked great. So I made a file called eudb.sql and
> entered '\i eudb.sql'.
> It does not single step, but flies through my
> creates and inserts. Why am I
> not getting single step with this file?
>
> thanks for help,
> Sam Deel
>
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Everybody's got to believe in something, I believe
> I'll have another beer...
>
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Chad Thompson 2002-08-12 19:35:15 Distinct On
Previous Message sdeel 2002-08-10 21:05:39 how do I get list of tables?