Re: psql and mysql

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