This was originally posted under PostgreSQL createdb changes Bruno Friedmann wrote:
> Hi Dan > > Can you check for constency with the other databases (Mysql/Sqlite) how are > spell the table,columns and their order in declaration. > I know we don't care about sensitive case under postgresql, but it would make > easier to migrate from one db to another > (dump stupid sql) or csv file ( but actually you need to know the order to > re-import them) > > I've done many transformation for a job like this one month ago. (was on my > todo list ... ) > Perharps we need to have some sort of reflexion, as I've not checked if > bacula save catalog job use full insert or not. I think you are asking me to make the PostgreSQL names case-sensitive. I would rather not do that. Here is why: test=# create table "Pool" (col1 text); CREATE TABLE test=# select * from pool; ERROR: relation "pool" does not exist test=# select * from Pool; ERROR: relation "pool" does not exist test=# select * from "Pool"; col1 ------ (0 rows) test=# That is, you MUST use double quotes. As for the ordering of the columns, I agree, the column orders should be the same. Do you have notes from the transformations you did? ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
