Re: Moving from MySQL to PGSQL....some questions - Mailing list pgsql-general

From Karl O. Pinc
Subject Re: Moving from MySQL to PGSQL....some questions
Date
Msg-id 20040228155435.I20755@mofo.meme.com
Whole thread Raw
In response to Re: Moving from MySQL to PGSQL....some questions  ("Greg Patnude" <gpatnude@hotmail.com>)
List 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 by date:

Previous
From:
Date:
Subject: Re: Simplyfying many equals in a join
Next
From: Martijn van Oosterhout
Date:
Subject: Re: postmaster out of memory....