What's the output from 'mysql -e "SHOW DATABASES;"' on it's own look like?
Without seeing the raw output we're working with it's hard to be sure, but I would guess you want something like:
can someone help me with the find and replace command.
I have a input file which is in the below format:
0011200ALN00000000009EGYPT 000000000000199900000
0011200ALN00000000009EGYPT 000000000000199900000
0011200ALN00000000008EGYPT 000000000000199800000
0011200ALN00000000009EGYPT ... (20 Replies)
I am writing a shell script that checks all .c files to see if they use fprintf or printf. If a file does, then the line #include <stdio.h> is added to the top of the file, unless it's already there.
This is what I've got:
#!/bin/sh
egrep -l f?printf *.c | while read file;
do sed -i '1i\... (2 Replies)
Hi,
having some problems getting commandline mail to work for root user in ubuntu.
Ive installed the following packages - msmtp & mailx and the cert for gmail.
I've created 3 files: mailrc and msmtprc in /home/username directory
and /etc/exim4/passwd.client
mailrc
------
set... (0 Replies)
Hi Folks,
I was given a task to append three IP's at the end of a specific (and unique) line within a file on multiple servers.
I was not able to do that with the help of a script. All I could was:
for i in server1 server2 server3 server4
do
ssh $i
done
I know 'sed' could be used to... (5 Replies)
Hi,
How can i split a line of string into two lines.
I would like to format the below string:
Filesystem 1M-blocks Used Available Use% Mounted on /abc/def/xyz 34567 2345 12345 90% /test
to
Filesystem 1M-blocks Used Available Use% Mounted on
/abc/def/xyz 34567 2345 12345 90% /test
... (4 Replies)
Hello Guys,
I request anyone to do me a small help in using diff command for following.
I am trying to compare two files for content and wish to keep the content after the comparison (The resultant file can't be blank)
However, the first lines would be different in both files and I need diff... (2 Replies)
Hi..wanted a help regarding inserting a newline in an xml file using shell script.
i've an xml file which has the following data.
1. <?xml version="1.0" encoding="UTF-8"?>
2. <group>
3. <name>odcm</name>
4. contd....
I need to insert two new lines after line#2, so that the output... (14 Replies)
I have a file which has data in 8 lines:
10
34
6
1
4
46
67
31
I am trying to read each value into each different variable so that I use these variables in preparing my report.
Another option is to dynamically print each line values in the report like below:
users with privA:... (2 Replies)
Hi,
I had generated a report in my tool as followsoutput.txt
43.35
9
i needed the script to generate a new file like below
i want to append the text to each of these lines of my filenewoutputfile.txt should be
Total Amount : 43.35
Record Count:9
Regards,
Vasa Saikumar.
... (2 Replies)
Discussion started by: hemanthsaikumar
2 Replies
LEARN ABOUT CENTOS
show
SHOW(7) PostgreSQL 9.2.7 Documentation SHOW(7)NAME
SHOW - show the value of a run-time parameter
SYNOPSIS
SHOW name
SHOW ALL
DESCRIPTION
SHOW will display the current setting of run-time parameters. These variables can be set using the SET statement, by editing the
postgresql.conf configuration file, through the PGOPTIONS environmental variable (when using libpq or a libpq-based application), or
through command-line flags when starting the postgres server. See Chapter 18, Server Configuration, in the documentation for details.
PARAMETERS
name
The name of a run-time parameter. Available parameters are documented in Chapter 18, Server Configuration, in the documentation and on
the SET(7) reference page. In addition, there are a few parameters that can be shown but not set:
SERVER_VERSION
Shows the server's version number.
SERVER_ENCODING
Shows the server-side character set encoding. At present, this parameter can be shown but not set, because the encoding is
determined at database creation time.
LC_COLLATE
Shows the database's locale setting for collation (text ordering). At present, this parameter can be shown but not set, because the
setting is determined at database creation time.
LC_CTYPE
Shows the database's locale setting for character classification. At present, this parameter can be shown but not set, because the
setting is determined at database creation time.
IS_SUPERUSER
True if the current role has superuser privileges.
ALL
Show the values of all configuration parameters, with descriptions.
NOTES
The function current_setting produces equivalent output; see Section 9.26, "System Administration Functions", in the documentation. Also,
the pg_settings system view produces the same information.
EXAMPLES
Show the current setting of the parameter DateStyle:
SHOW DateStyle;
DateStyle
-----------
ISO, MDY
(1 row)
Show the current setting of the parameter geqo:
SHOW geqo;
geqo
------
on
(1 row)
Show all settings:
SHOW ALL;
name | setting | description
-------------------------+---------+-------------------------------------------------
allow_system_table_mods | off | Allows modifications of the structure of ...
.
.
.
xmloption | content | Sets whether XML data in implicit parsing ...
zero_damaged_pages | off | Continues processing past damaged page headers.
(196 rows)
COMPATIBILITY
The SHOW command is a PostgreSQL extension.
SEE ALSO SET(7), RESET(7)PostgreSQL 9.2.7 2014-02-17 SHOW(7)