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
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? |