Re: [HACKERS] [SQL] Case Preservation disregarding case

2006-12-02 Thread Dennis Bjorklund
Ken Johanson skrev: Although, since I'm using pgAdmin (III) to design tables in this case, or creating the tables through JDBC (a convenient way to copy tables and data from another datasource) (using the copy-paste gesture), I believe those tools both *are* quoting identifiers that have camel

Re: [HACKERS] [SQL] Case Preservation disregarding case

2006-12-02 Thread Dennis Bjorklund
Ken Johanson skrev: Has your experience with PG been different? If so I presume you have have found a config that allows?: SELECT pers.firstName, pers.lastname, As long as you don't create the columns using quotes you can use that kind of names. For example CREATE TABLE foo (BAR int);

Re: [SQL] [GENERAL] MD5() function not available ??

2003-09-13 Thread Dennis Bjorklund
On Thu, 11 Sep 2003, Marek Lewczuk wrote: > I've searched for MD5 crypting function in PG, but I did not find it. > Anyone knows how to implement this function in PG ? It's implemented in the pgcrypto module that is in contrib in the tarball. Once you have added that you can for example do denn