Skip site navigation (1) Skip section navigation (2)

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

From: "Karl O(dot) Pinc" <kop(at)meme(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Moving from MySQL to PGSQL....some questions
Date: 2004-02-28 21:54:35
Message-ID: 20040228155435.I20755@mofo.meme.com (view raw or flat)
Thread:
Lists: pgsql-general
> "Karam Chand" <karam_chand03(at)yahoo(dot)com> wrote in message
> news:20040225145704(dot)40397(dot)qmail(at)web60804(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
> >
> > 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(at)meme(dot)com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein

In response to

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2004-02-28 22:18:38
Subject: Re: Irreversible performance drop after increasing shared mem
Previous:From: Mike FuterkoDate: 2004-02-28 21:12:11
Subject: pgCluster in production environment

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group