Re: Dumb postgresql questions

[Jorge Santos <jsf@dep3.fciencias.unam.mx>]

Corey Halpin <crhalpin@students.wisc.edu> writes:

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

You can always dump the mysql database into a file (although I don't
know how you would do that) and then load it into postgresql with
something like:

psql <databasename> <databaseuser> < <dumped_database>

>   2. what postgresql commands are equivalent to "show databases;" and "show 
> tables;" in mysql?
> 
> thanks,
> crh
> -- 
> Corey R. Halpin (http://www.cae.wisc.edu/~halpin/ )
> Student of Electrical Engineering and Computer Sciences
> University of Wisconsin-Madison
> 
> 
> 
> 
> -- 
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org 
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org