Re: [SQL] [NOVICE] Understanding Encoding

2013-09-06 Thread Amit Langote
: 0xa0 0x88 I changed the encoding of the terminal emulator (GNOME Terminal 2.31.3) using the Terminal menu as: Terminal -> Set 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

Re: [SQL] [NOVICE] Understanding Encoding

2013-09-05 Thread Amit Langote
hing 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-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[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 , instead there should be two entries in the

[SQL] Query for block updates

2006-12-03 Thread Amit Shah
moved :-( Thanks, Amit ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[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

[SQL] Problem in Porting from Oracle to Postgres SQl

2001-05-11 Thread Amit
ied create 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