| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2004-02-28 22:18:38 | Re: Irreversible performance drop after increasing shared mem |
| Previous Message | Mike Futerko | 2004-02-28 21:12:11 | pgCluster in production environment |