Re: Dumb postgresql questions

[Andrew Perrin <aperrin@email.unc.edu>]

On Mon, 5 Nov 2001, Corey Halpin wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Content-Type: text/plain; charset=us-ascii
> 
>   1. Is there some simple way to convert a mysql database into a postgresql 
> database?

I don't know the answer to this one.

>   2. what postgresql commands are equivalent to "show databases;" and "show 
> tables;" in mysql?
> 

To show tables:
\d <databasename>


To show databases:
\l

(that's an "ell", not a "one")



----------------------------------------------------------------------
Andrew J Perrin - andrew_perrin@unc.edu - http://www.unc.edu/~aperrin
 Assistant Professor of Sociology, U of North Carolina, Chapel Hill
      269 Hamilton Hall, CB#3210, Chapel Hill, NC 27599-3210 USA