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

Re: psql and mysql

From: jcradock(at)me3(dot)com
To: "YL" <elim(at)pdtnetworks(dot)net>
Cc: "Psql_General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql and mysql
Date: 2005-04-02 23:15:49
Message-ID: 32905.66.63.75.161.1112483749.squirrel@secure.me3.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
A significant difference, and something that might be frustrating, is
listing databases and database objects and describing tables. To list
databases, type

\l

...and hit RETURN. To list tables in the database you've logged in to, type

\dt

If you've got some familiarity with MySQL then querying database objects
should be easy in PostgreSQL, altough PostgreSQL does obviously support
some features and thus some commands not available in MySQL. There will be
some learning there, possibly, but I think you'll find it easy. Type

\?

...and press RETURN to see the full set of options. I definitely recommend
reading the docs:

http://www.postgresql.org/docs/current/static/app-psql.html

Enjoy!

Jim

> Dear List,
> I'm new to Psql and very eager to learn the differences between these two
> RDBMS.
> Any help is greatly appreciated.
> Thanks
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>



-----
James Cradock, jcradock(at)me3(dot)com



In response to

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2005-04-02 23:16:32
Subject: Re: [GENERAL] plPHP in core?
Previous:From: Christopher BrowneDate: 2005-04-02 22:21:22
Subject: Re: psql and mysql

pgsql-general by date

Next:From: Marc G. FournierDate: 2005-04-02 23:16:32
Subject: Re: [GENERAL] plPHP in core?
Previous:From: Christopher BrowneDate: 2005-04-02 22:21:22
Subject: Re: psql and mysql

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