Nick Rout wrote:
> Yes but at any stage you can dump the database generating scripts - wel
you can in mysql, I assume you can in postgresql too.
Yes, you can.
You can even dump the scripts to populate the tables as a text file with
inserts. This means you can even very easily port your database to
another RDBMS.
See:
man pg_dump
<offtopic rant>
Funnily enough MS-SQL doesn't have that particular functionality.
It is very hard to get the MS-SQL engine to produce a sql dump of an
entire database. (and before anyone says it I know you can make a dump
of a DB but you can't make a *SQL* dump in human readable form. )You can
get 3rd party things that can do it but the ones I've seen produce
extremely MS-SQL specific syntax.
I suppose you could write a program yourself but MS don't make it very easy.
<\offtopic rant>
