7
7
*
8
8
*
9
9
* IDENTIFICATION
10
- * $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.79 1997/08/01 03:33:02 momjian Exp $
10
+ * $Header: /cvsroot/pgsql/src/bin/psql/Attic/psql.c,v 1.80 1997/08/01 04:07:55 momjian Exp $
11
11
*
12
12
*-------------------------------------------------------------------------
13
13
*/
@@ -123,7 +123,7 @@ usage(char *progname)
123
123
fprintf (stderr , "\t -d dbName specify database name\n" );
124
124
fprintf (stderr , "\t -e echo the query sent to the backend\n" );
125
125
fprintf (stderr , "\t -f filename use file as a source of queries\n" );
126
- fprintf (stderr , "\t -F sep set the field separator (default is " | " )\n" );
126
+ fprintf (stderr , "\t -F sep set the field separator (default is '|' )\n" );
127
127
fprintf (stderr , "\t -h host set database server host\n" );
128
128
fprintf (stderr , "\t -H turn on html3.0 table output\n" );
129
129
fprintf (stderr , "\t -l list available databases\n" );
@@ -164,7 +164,7 @@ slashUsage(PsqlSettings * ps)
164
164
pqsignal (SIGPIPE , SIG_IGN );
165
165
}
166
166
else
167
- fout = stderr ;
167
+ fout = stdout ;
168
168
169
169
fprintf (fout , " \\? -- help\n" );
170
170
fprintf (fout , " \\a -- toggle field-alignment (currenty %s)\n" , on (ps -> opt .align ));
@@ -621,15 +621,15 @@ SendQuery(bool * success_p, PsqlSettings * settings, const char *query,
621
621
case PGRES_COMMAND_OK :
622
622
* success_p = true;
623
623
if (!settings -> quiet )
624
- fprintf ( stdout , "%s\n" , PQcmdStatus (results ));
624
+ printf ( "%s\n" , PQcmdStatus (results ));
625
625
break ;
626
626
case PGRES_COPY_OUT :
627
627
* success_p = true;
628
628
if (copy_out ) {
629
629
handleCopyOut (results , settings -> quiet , copystream );
630
630
} else {
631
631
if (!settings -> quiet )
632
- fprintf ( stdout , "Copy command returns...\n" );
632
+ printf ( "Copy command returns...\n" );
633
633
634
634
handleCopyOut (results , settings -> quiet , stdout );
635
635
}
@@ -693,7 +693,7 @@ toggle(PsqlSettings * settings, bool * sw, char *msg)
693
693
{
694
694
* sw = !* sw ;
695
695
if (!settings -> quiet )
696
- fprintf ( stderr , "turned %s %s\n" , on (* sw ), msg );
696
+ printf ( "turned %s %s\n" , on (* sw ), msg );
697
697
return * sw ;
698
698
}
699
699
@@ -869,9 +869,9 @@ do_copy(const char *args, PsqlSettings * settings)
869
869
fclose (copystream );
870
870
if (!settings -> quiet ) {
871
871
if (success )
872
- fprintf ( stdout , "Successfully copied.\n" );
872
+ printf ( "Successfully copied.\n" );
873
873
else
874
- fprintf ( stdout , "Copy failed.\n" );
874
+ printf ( "Copy failed.\n" );
875
875
}
876
876
}
877
877
}
@@ -1046,14 +1046,16 @@ do_help(const char *topic)
1046
1046
char * pagerenv ;
1047
1047
FILE * fout ;
1048
1048
1049
- if ((pagerenv = getenv ("PAGER" )) && (pagerenv [0 ] != '\0' ) && \
1049
+ if (strcmp (topic , "*" ) == 0 &&
1050
+ (pagerenv = getenv ("PAGER" )) &&
1051
+ (pagerenv [0 ] != '\0' ) &&
1050
1052
(fout = popen (pagerenv , "w" )))
1051
1053
{
1052
1054
usePipe = 1 ;
1053
1055
pqsignal (SIGPIPE , SIG_IGN );
1054
1056
}
1055
1057
else
1056
- fout = stderr ;
1058
+ fout = stdout ;
1057
1059
1058
1060
help_found = false; /* Haven't found it yet */
1059
1061
for (i = 0 ; QL_HELP [i ].cmd ; i ++ ) {
@@ -1075,7 +1077,7 @@ do_help(const char *topic)
1075
1077
}
1076
1078
1077
1079
if (!help_found )
1078
- printf ( "command not found, "
1080
+ fprintf ( stderr , "command not found, "
1079
1081
"try \\h with no arguments to see available help\n" );
1080
1082
}
1081
1083
}
@@ -1291,7 +1293,7 @@ HandleSlashCmds(PsqlSettings * settings,
1291
1293
exit (1 );
1292
1294
}
1293
1295
if (!settings -> quiet )
1294
- fprintf ( stderr , "field separater changed to '%s'\n" , settings -> opt .fieldSep );
1296
+ printf ( "field separater changed to '%s'\n" , settings -> opt .fieldSep );
1295
1297
break ;
1296
1298
}
1297
1299
case 'g' : /* \g means send query */
@@ -1346,7 +1348,7 @@ HandleSlashCmds(PsqlSettings * settings,
1346
1348
case 'r' : /* reset(clear) the buffer */
1347
1349
query [0 ] = '\0' ;
1348
1350
if (!settings -> quiet )
1349
- fprintf ( stderr , "buffer reset(cleared)\n" );
1351
+ printf ( "buffer reset(cleared)\n" );
1350
1352
break ;
1351
1353
case 's' : /* \s is save history to a file */
1352
1354
if (!optarg )
@@ -1364,13 +1366,13 @@ HandleSlashCmds(PsqlSettings * settings,
1364
1366
free (settings -> opt .fieldSep );
1365
1367
settings -> opt .fieldSep = strdup ("|" );
1366
1368
if (!settings -> quiet )
1367
- fprintf ( stderr , "field separater changed to '%s'\n" , settings -> opt .fieldSep );
1369
+ printf ( "field separater changed to '%s'\n" , settings -> opt .fieldSep );
1368
1370
} else {
1369
1371
if (settings -> opt .fieldSep )
1370
1372
free (settings -> opt .fieldSep );
1371
1373
settings -> opt .fieldSep = strdup (DEFAULT_FIELD_SEP );
1372
1374
if (!settings -> quiet )
1373
- fprintf ( stderr , "field separater changed to '%s'\n" , settings -> opt .fieldSep );
1375
+ printf ( "field separater changed to '%s'\n" , settings -> opt .fieldSep );
1374
1376
}
1375
1377
break ;
1376
1378
case 'z' : /* list table rights (grant/revoke) */
0 commit comments