If you look at the options for pgdump you can set it up to dump the data as fully qualified SQL INSERT statements, and I'm pretty sure that you can limit it to the data only, but if not you can always load the resulting script into vi and hack out the create table statements. --rick Matt Murphy wrote: >>The phpBB software will create the appropriate tables in the database. >>I'm wondering if I can do a pg_dump from Postgres with the data only >>and get that into the newly created MySQL tables for phpBB? Has anyone >>done this before? >> >> > > Does Postgres have anything like phpmyadmin? (or maybe you know the commands?) I know with mysql you can dump a database to a .sql file, which is just a list of sql commands to re add the data to a new database. I think most of the syntax is the same between postgres and mysql, though I could be wrong, if not you may have to edit the file a bit after dumping, but if you know the commands it's pretty straightforward. > >Good luck, > >Matt > > >_______________________________________________ >TCLUG Mailing List - Minneapolis/St. Paul, Minnesota >http://www.mn-linux.org tclug-list at mn-linux.org >https://mailman.real-time.com/mailman/listinfo/tclug-list > > _______________________________________________ TCLUG Mailing List - Minneapolis/St. Paul, Minnesota http://www.mn-linux.org tclug-list at mn-linux.org https://mailman.real-time.com/mailman/listinfo/tclug-list