[SQL] to restore database in schema

2007-09-28 Thread Penchalaiah P.
Hi ... Under one database who's name is postgres ,its contains 2 schema's 1)cdao1 2)cdao2. I want to restore one database into schema 2.(cdao2)...here there is no option to restore... I can restore into one database,but I cant restore into schema...may I know y its happening... Any one can

Re: [SQL] problems with copy

2007-09-28 Thread Luis Carlos Ferreira
El Lun 24 Sep 2007 21:38, chester c young escribió: > I'm getting lots of delimited files from Excel and MySQL users that, > mid-file, begin truncating lines if ending in null values. > > for example: > 1781: "one","two","three",, > 1782: "one","two","three",, > 1783: "one","two","three",, >

Re: [SQL] to restore database in schema

2007-09-28 Thread Richard Huxton
Penchalaiah P. wrote: Hi ... Under one database who's name is postgres ,its contains 2 schema's Probably not a good idea to use the "postgres" database for casual usage. Any reason why you're not using a new database? 1)cdao1 2)cdao2. OK I want to restore one database into schema 2.(cd