144 reputation
7
bio website
location
age
visits member for 1 year, 9 months
seen Oct 10 at 16:30

Sep
16
accepted trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error
Aug
8
comment How to determine if postgres database contains GiST indexes and what type?
Thanks! This worked! The command did not produce any results, but that was somewhat expected as most of our indexes are btree.
Aug
8
accepted How to determine if postgres database contains GiST indexes and what type?
Aug
7
asked How to determine if postgres database contains GiST indexes and what type?
Apr
23
awarded  Popular Question
Aug
7
awarded  Commentator
Aug
7
comment Confused over encoding/locale in postgresql
Thanks! that helped a lot. So just to make it clear, the LC_CTYPE has to be a subset of the characters represented in the encoding? So the LC_CTYPE tells you which characters in the encoding your allowed to use and which ones you cannot use?
Aug
7
accepted Confused over encoding/locale in postgresql
Aug
6
asked Confused over encoding/locale in postgresql
Jul
17
accepted issues with encoding and pg_dump/restore between windows and linux
Apr
21
awarded  Teacher
Apr
21
answered trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error
Apr
20
revised trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error
added 26 characters in body
Apr
20
asked trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error
Mar
12
comment Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
@a_horse_with_no_name I am installing postgresql from the executable available on enterpriseDB. The executable installs postgres and also sets up a database cluster with a default database. I guess I could delete the default cluster and then setup a new one but I would like to know how to make it so the installer installs the data cluster as WIN1252 instead of UTF8. It originally installed it as WIN1252 but I somehow switched it to install as UTF8 and would like to switch it back.
Mar
12
comment Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
@a_horse_with_no_name I want to install postgres and have the default database be WIN1252. Currently when I install postgres, the database is UTF8
Mar
12
revised Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
added more info
Mar
12
asked Install PostgreSQL 9.2 on Windows using WIN1252 encoding.
Feb
20
awarded  Student
Feb
20
revised issues with encoding and pg_dump/restore between windows and linux
added 709 characters in body