On Mon, November 20, 2006 1:02 pm, Alain Roger wrote: > I would like to know if under PHP i can setup the default schema for a > PostgreSQL database ? > > e.g if my database name is 'mydb', my schema 'immense', i would like > to > avoid : > > immense.my_function_name(parameter1, parameter2,..) > > ... > select * from immense.table1 WHERE immense.table1.field1 = > immense.table2.field5; This isn't really a PHP question... Either PostgreSQL (http://postgresql.org) supports that sort of thing, or it doesn't. And, actually, in normal usage, you choose the DB when you connect, and the table name is only used where needed to distinguish same-named columns. And your notion of 'schema', afaik, doesn't appear at all, in all the code I've ever seen/used. Which is not to say that PostgreSQL doesn't suppor it. For all I know, it's the greatest thing since sliced bread and pg_* supports it very nicely. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some starving artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
