Re: Moving from MySQL to PGSQL....some questions

Поиск
Список
Период
Сортировка
От Karl O. Pinc
Тема Re: Moving from MySQL to PGSQL....some questions
Дата
Msg-id 20040228155435.I20755@mofo.meme.com
обсуждение исходный текст
Ответ на Re: Moving from MySQL to PGSQL....some questions  ("Greg Patnude" <gpatnude@hotmail.com>)
Список pgsql-general
> "Karam Chand" <karam_chand03@yahoo.com> wrote in message
> news:20040225145704.40397.qmail@web60804.mail.yahoo.com...
> >
> > 5.) In MySQL, there are many command like show tables,
> > show databases etc. to get object details. I cant see
> > anything similar in PGSQL. After searching the net i
> > find that i have to execute certain queries to fetch
> > those queries. Is this the only way?

One easy way is to use the psql command line program
and the \d command.  It lists all your tables,
lists all the columns in a table, etc.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

В списке pgsql-general по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: Simplyfying many equals in a join
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: postmaster out of memory....