Exporting Data to text file in Postgres:

Recently i was asked to export data from postgresql to a text file. Tried many tricks. But they didnt. Atlast the syntax given the following works properly.

test=>\o /home/sample.txt(i.e the path of the text file which should be already created)
test=>query that wants to be executed will be given here;
test=>\o

The first \o is similar to opening the output stream  which should give the name of the text file with full path. A text file will not be created by giving this. It just redirects the output stream to the file. So the text file should be created already.In the next sentence the query that needs to be executed will be given and in the third line the output stream is closed.

BSNL Sucks:

For more than a month, sancharnet users were not able to access many of the sites because of some dns problem. I wonder whether people at BSNL did not realize their problem for a month. Even at the small industries or organisations maintenance works are done properly. But BSNL didn’t. I could not even check yahoo mail or I couldn’t post in wordpress. After the long waiting, I am now able to post this…

Review : First Half Of The Final Year

Just sitting back and thinking of what i have learnt for the whole semester. Sitting in corner place of the class and hearing the lecture delivered by vanni and subbi. Here comes senthil and sriram. They will prove that they are very good listeners by doing the same but sitting in front bench. But their ears will be rolling towards back only. Always speaking,speaking,speaking…… This semester we have zeroth review for our project which was nice. Hope to continue the same by contributing to goaTee and completing it at the end of the next semester.