Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Amit Langote
the SELECT statement displays something different. I am not able to understand why? korean=# SELECT * FROM tbl; doc �׷��� (1 row) I wonder if you have tried changing your locale to ko_KR; something like: LANG=ko_KR LC_ALL=ko_KR \ psql -d korean -- Amit Langote -- Sent via pgsql

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Amit Langote
Character Encoding - Korean (EUC-KR) Note that, if the menu only lists UTF-8, you'd have to add EUC-KR using Add or Remove. And it seems to work; could you try the same? -- Amit Langote -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http

[SQL] Indexing question

2012-08-15 Thread amit sehas
In SQL, given a table T, with two fields f1, f2, is it possible to create an index such that the same record is indexed in the index, once with field f1 and once with field f2. (I am not looking for a compound index in which the key would look like f1, f2, instead there should be two entries

[SQL] How to configure postgresql to accept TCP/IP connections

2005-04-22 Thread amit kumar awasthi
Hello sir actually i am working with Qt using postgresql i have to get connection {(database(trainee),user(trainee))} from the network (database remote accessing) so i have configured postgresql.conf and pg_hba.conf upto some extents the fields that i have configured r as follows even then

[SQL] Problem in Porting from Oracle to Postgres SQl

2001-05-11 Thread Amit
ate temp table But it not works.. Is there any way to use arrays. 2> There is one function in Oracle Executesql '...' to execute and what i got in Postgres is Execute immediate '.' But it is giving error at Execute. I will be very thankful if any one help me. Amit ( India )