Thread: Database Creation Script
How do I generate a database creation script for an existing database? What's the best documentation available for postgresql? Please forgive the newbie questions.
On Tue, 23 Feb 1999 strawman@plexi.com wrote: > How do I generate a database creation script for an existing database? > > What's the best documentation available for postgresql? > > Please forgive the newbie questions. I've used from the command line: pg_dump dbname -f filename -z -v to create the sql creation scripts as well as the data. I believe I originally found this in the documentation available at http://www.postgresql.org also 'man pg_dump' will give you some info. Kevin -------------------------------------------------------------------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612 kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net --------------------------------------------------------------------
On Tue, 23 Feb 1999 strawman@plexi.com wrote: > > How do I generate a database creation script for an existing database? > pg_dump/pg_dumpall I thought there was a manpage for it but I can't find it on my system. > What's the best documentation available for postgresql? > The only docs I know about are the ones that came with it, and their copies on www.postgresql.org ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-< James Thompson 138 Cardwell Hall Manhattan, Ks 66506 785-532-0561 Kansas State University Department of Mathematics ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<