Обсуждение: how do I get list of tables?

Поиск
Список
Период
Сортировка

how do I get list of tables?

От
"sdeel"
Дата:
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...
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-



Re: how do I get list of tables?

От
marc sturm
Дата:
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@cox.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