Wednesday, January 30, 2013
Postgres Tips
1. If you are like me: stuck with a command line terminal and need to view large database tables, you should try the '\x' command in Postgres. This is called the extended display mode and is pretty useful.
2. You should also check out the '.pgpass' option in postgres. You can save you password into a file so that you don't have to type it in every time. This is also useful if you wan to write scripts and stuff.
3. Postgres commands starting with a '\' are called meta-commands and they can be used in script. Here's a way to do it.
2. You should also check out the '.pgpass' option in postgres. You can save you password into a file so that you don't have to type it in every time. This is also useful if you wan to write scripts and stuff.
3. Postgres commands starting with a '\' are called meta-commands and they can be used in script. Here's a way to do it.
Thursday, January 24, 2013
VIM Plugin and other fancies
I need a VIM plugin that limits the length of lines in the text files I write. In case, I exceed the line length, it should automatically wrap it up. It is not pleasing to look at variable line lengths in a text document. Something simple like the word wrap in a windows notepad. May be, its a built in feature in vim already. I'll look it up and update this post.
Also, I don't like this idea of blogging in this text editor like thingy. I wonder, if I can enter this post in a webpage like environment. If not, I will end up spending most of my time on Blogger looking at this again text editor instead of my template.
Also, I don't like this idea of blogging in this text editor like thingy. I wonder, if I can enter this post in a webpage like environment. If not, I will end up spending most of my time on Blogger looking at this again text editor instead of my template.
Subscribe to:
Comments (Atom)