[GENERAL] Select All Columns

2005-09-01 Thread Tan Chen Yee
If I want to retrieve all columns from a table, is there any disadvantage by using select * instead of listing all the columns ? Will select * cause overhead, more times to run ? Thanks ! Tan ---(end of broadcast)--- TIP 1: if posting/reading thro

[GENERAL] Restore PLAIN file

2005-08-04 Thread Tan Chen Yee
Hi, I have backup a database in plain text format. I know I cannot use pgadmin III to restore it. What is other way to do the restoration ? Thanks ! TAn ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Cannot start DB system

2005-07-20 Thread Tan Chen Yee
"127.0.0.1" and accepting TCP/IP connections on port 5432? If the db system is crashed, how do I fix it ? Any help is really appreciated. Thanks ! Tan Chen Yee ---(end of broadcast)--- TIP 6: explain analyze is your friend