01-12-2009
Get information like substring
I retrieved values from postgresql database
return the following line
name ------------ myname (1 row)
how can I extract "myname" out of the line?
thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have several lines like this ones:
123456789abcde /aa/bb/123456_$data.log
123456789abcde /aa/bb/123456_not_a_data_log
987654321ab /aa/bb/xpto123456_$data.log
...
How do I get into a variable the value "/aa/bb/123456_$data.log" , searching only for the beggining and ending... (3 Replies)
Discussion started by: Scarlos
3 Replies
2. Shell Programming and Scripting
This is probably pretty simple butI'm not sure how to best go about it.
If I have
FILE="myBigLongFileName_1.xls"
FILE_PREFIX=`echo $FILE| cut -d"." -f1`
# that gives "myBigLongFileName_1"
All i want to do now is chop the "_1" from the end of $FILE_PREFIX
Any ideas anyone? (3 Replies)
Discussion started by: djkane
3 Replies
3. Shell Programming and Scripting
i have a strings
abc-def.csv
ghi-jkl.csv
i want to make it as
abc-*-def.xyz
ghi-*-jkl.xyz
How to do it?. (5 Replies)
Discussion started by: senthilk615
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a value of a filepath in a variable
DATAFILE with value as "customtop/gpsore37/gepspo/1.0/bin/ashoka.csv
".
Now i want the value of last 4 charcters in to another variable.
That is EXTENSION = .csv
How can i do this in Shell scripting
Thanks in advance
Alla Kishore (8 Replies)
Discussion started by: alla.kishore
8 Replies
5. UNIX for Dummies Questions & Answers
I need to check the occurrence of one string within another.
code
********************
if ;then do something done
********************
Thanks (7 Replies)
Discussion started by: w020637
7 Replies
6. UNIX for Dummies Questions & Answers
Hi
I use the below cmd to get the list of files that are modified than <temp> file in the <path> diretory
cmd:find <path> -name '*.zip' -type f -newer <temp> -print
i am getting all the list of files that are new or modified, with abs path, i want to copy all of these files to a... (3 Replies)
Discussion started by: Naveen_5960
3 Replies
7. Shell Programming and Scripting
I have a string '<Hi>abc</Hi>"
How to print "abc" (6 Replies)
Discussion started by: sandy1028
6 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I hav a string lets say aa.txt:bb:txt
length of the string can vary.. I have to keep the token inside a array and the delimiter is : plz send me the code (2 Replies)
Discussion started by: Deekay.p
2 Replies
9. Shell Programming and Scripting
Hi All,
I have a ouput string likes 'u8wos' or 'u10acsd' or somthing else 'u{number}{any characters}'and I want to get the number behind the letter 'u' by bash shell.
Thanks
Damon (11 Replies)
Discussion started by: Damon_Qu
11 Replies
10. UNIX for Dummies Questions & Answers
Hi,
My requirement is to get the substring and then remove special character.
Ex
I have data like T_SYSTEM_XXXXX_YYYY_ZZZ
I want to get XXXXXYYYYZZZ
the part after T_SYSTEM is varying it might be XXX_YY or just XX
can you tell me which all commands i have to use.
i understand i... (5 Replies)
Discussion started by: Mohammed_Tabish
5 Replies
LEARN ABOUT DEBIAN
postgresql_autodoc
POSTGRESQL_AUTODOC(1) General Commands Manual POSTGRESQL_AUTODOC(1)
NAME
postgresql_autodoc - creates postgresql tables overview
SYNOPSIS
postgresql_autodoc [options]
DESCRIPTION
This is a utility which will run through PostgreSQL system tables and returns HTML, DOT, and 2 styles of XML which describes the database.
The HTML is human readable (via webbrowser). The first style of XML is actually the fileformat of Dia, a UML diagram tool. The second type
of XML is similar to the HTML but in the Docbook 4 format. It enables yous to mix in other docbook documentation via the XREFs, generating
PDFs, HTML, RTF, or other formatted documents. Between these tools and JavaDoc with the appropriate XREFs, documentation about a project
can be generated quickly and be easily updatable yet have a very professional look with some DSSSL work.
OPTIONS
-d <dbname>
Specify database name to connect to (default: $database)
-f <file>
Specify output file prefix (default: $database)
-h <host>
Specify database server host (default: localhost)
-p <port>
Specify database server port (default: 5432)
-u <username>
Specify database username (default: $dbuser)
--password=<pw>
Specify database password (default: blank)
-l <path>
Path to the templates (default: /usr/share/postgresql-autodoc)
-t <output>
Type of output wanted (default: All in template library)
-s <schema>
Specify a specific schema to match. Technically this is a regular expression but anything other than a specific name may have
unusual results.
--statistics
In 7.4 and later, with the contrib module pgstattuple installed we can gather statistics on the tables in the database (average
size, free space, disk space used, dead tuple counts, etc.) This is disk intensive on large databases as all pages must be visited.
AUTHOR
Rod Taylor <autodoc@rbt.ca>
21/01/2005 POSTGRESQL_AUTODOC(1)