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.
No comments:
Post a Comment