Re: [GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread Sukuchha Shrestha
Von: Pavel Stehule An: Sukuchha Shrestha CC: pgsql-general@postgresql.org Gesendet: Montag, den 16. Mai 2011, 15:06:14 Uhr Betreff: Re: [GENERAL] Remove Duplicate Words from a field Hello 2011/5/16 Sukuchha Shrestha : > Dear All, > I am new to Postgresql. I have a field wit

[GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread Sukuchha Shrestha
Dear All, I am new to Postgresql. I have a field with lots of dublicate words and i want to remove any dublicate word from that field. For example, if i have a field with a string " one, one, two, two, three", how would i get " one, two, three" only ? Any help is much apprecieated ! Sukuchha

[GENERAL] Connecting matlab with postgresql

2011-04-29 Thread Sukuchha Shrestha
Hello nice people, I am sure many of you have idea about how to connect matlab with postgresql. Connecting with matab database toolbox is possible which i have not tried yet because i dont have access to that toolbox. I have read in internet that its possible to connect without having a databas

[GENERAL] load sql from the file in postgresql

2011-04-29 Thread Sukuchha Shrestha
hello group, I just started to use postgresql and i want to import data using copy command in a loop. Here is what i did ! 1) following content with name loaddata.sql. \copy table from 'C:\psql\x.txt'; \copy table from 'C:\psql\y.txt'; 2) My loaddata.sql is located in C:\psql\ therefore i tri