10-03-2013
Hi Scoot,
THanks for the reply, As i told its a file extracted from a database table with '~' as a delimitter; The file might contain arbitrary No. of columns each time. Strings is not converting the entire file properly as expected. Is there any other command/script that will help me?
10 More Discussions You Might Find Interesting
1. Programming
please let me know that in unix using c programming language we can do binary to string conversion and vice versa using ltoa and atol but how can we do it in c++ programming language.
thank you in advance. (3 Replies)
Discussion started by: kinnaree
3 Replies
2. UNIX for Advanced & Expert Users
Dear All,
Business Users are transfering ( FTP ) a CSV file into the IBM AIX box with transfer mode as ASCII. But I want to convert the CSV file from ASCII mode into binary mode, as my script expects file in binary mode.
Is it possible to do through Unix commands?
Thanks in Advance,
RK (1 Reply)
Discussion started by: srajeshmca
1 Replies
3. Shell Programming and Scripting
Hi,
I have a pdf file. i want to convert it to text file and do some work on it and later want to convert it back to pdf. Can this be done via unix?
or
Is there a way unix can directly work on PDF file? (2 Replies)
Discussion started by: saltysumi
2 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am new to Unix and discovered this example problem online that I believe will help my learning:
Run the command's below
env >> xx
env >> xx
env >> xx
env >> xx
env >> xx
You will now have a file called XX with the env redirected into it 5 times
Create a script named... (2 Replies)
Discussion started by: Jimmy_c
2 Replies
5. Shell Programming and Scripting
shell script to convert file names from UPPERCASE to lowercase file names or vice versa in linux
anybody please help me out!!!! (5 Replies)
Discussion started by: jacky29
5 Replies
6. Ubuntu
i am thinking of replacing my vista with ubuntu.
Questions:
1) what will be the advantages and disadvantages of using ubuntu instead of vista?
2) what will be the setbacks of replacing my vista?
3) how hard is it to cope up with the new OS? what must i learn to utilize ubuntu? (1 Reply)
Discussion started by: Anna Hussie
1 Replies
7. Shell Programming and Scripting
I need to write a script that will take the input from a file and convert the number from centigrade to fahrenheit and vice versa.
This is what I have but it doesn't seem to be correct.
Also the data file has 11 numbers inside of it and the output needs to be listed as so:
Fahrenheit Temperature... (18 Replies)
Discussion started by: N1ckNak
18 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I installed Oracle virtual box 4.1.8 on my desktop. I installed Windows 2008 server R2 as one instance and Solaris 10 as another instance. When am trying to ping from Windows to solaris and vice-versa, ping not working.
windows IP : 10.1.47.24
Solaris IP : 10.1.47.25
netstat... (2 Replies)
Discussion started by: kjks
2 Replies
9. Shell Programming and Scripting
Hello All,
I have a below data in a .csv file where all rows where col1 is A, col2 is odd numbers, similarly even numbers for all rows where col1 is B.
Note that my data has some other columns(not shown here) too (around 100) after col2.
Tool,Data
A,1
A,3
A,5
....
so on
B,2
B,4
.... ... (4 Replies)
Discussion started by: ks_reddy
4 Replies
10. UNIX for Dummies Questions & Answers
Hi,
In unix or linux is there any command exist to identify Host Name to IP Address or Vice Versa?
Thanks in advance (6 Replies)
Discussion started by: nag_sathi
6 Replies
LEARN ABOUT REDHAT
vacuumdb
VACUUMDB(1) PostgreSQL Client Applications VACUUMDB(1)
NAME
vacuumdb - garbage-collect and analyze a PostgreSQL database
SYNOPSIS
vacuumdb [ connection-options... ] [ --full | -f ] [ --verbose | -v ] [ --analyze | -z ] [ --table | -t 'table [ ( column [,...] ) ]' ] [
dbname ]
vacuumdb [ connection-options... ] [ --all | -a ] [ --full | -f ] [ --verbose | -v ] [ --analyze | -z ]
DESCRIPTION
vacuumdb is a utility for cleaning a PostgreSQL database. vacuumdb will also generate internal statistics used by the PostgreSQL query
optimizer.
vacuumdb is a shell script wrapper around the backend command VACUUM [vacuum(7)] via the PostgreSQL interactive terminal psql(1). There is
no effective difference between vacuuming databases via this or other methods. psql must be found by the script and a database server must
be running at the targeted host. Also, any default settings and environment variables available to psql and the libpq front-end library do
apply.
vacuumdb might need to connect several times to the PostgreSQL server, asking for a password each time. It is convenient to have a
$HOME/.pgpass file in such cases.
OPTIONS
vacuumdb accepts the following command-line arguments:
[-d] dbname
[--dbname] dbname
Specifies the name of the database to be cleaned or analyzed. If this is not specified and -a (or --all) is not used, the database
name is read from the environment variable PGDATABASE. If that is not set, the user name specified for the connection is used.
-a
--all Vacuum all databases.
-e
--echo Echo the commands that vacuumdb generates and sends to the server.
-f
--full Perform ``full'' vacuuming.
-q
--quiet
Do not display a response.
-t table [ (column [,...]) ]
--table table [ (column [,...]) ]
Clean or analyze table only. Column names may be specified only in conjunction with the --analyze option.
Tip: If you specify columns to vacuum, you probably have to escape the parentheses from the shell.
-v
--verbose
Print detailed information during processing.
-z
--analyze
Calculate statistics for use by the optimizer.
vacuumdb also accepts the following command-line arguments for connection parameters:
-h host
--host host
Specifies the host name of the machine on which the server is running. If host begins with a slash, it is used as the directory for
the Unix domain socket.
-p port
--port port
Specifies the Internet TCP/IP port or local Unix domain socket file extension on which the server is listening for connections.
-U username
--username username
User name to connect as
-W
--password
Force password prompt.
DIAGNOSTICS
VACUUM Everything went well.
vacuumdb: Vacuum failed.
Something went wrong. vacuumdb is only a wrapper script. See VACUUM [vacuum(7)] and psql(1) for a detailed discussion of error mes-
sages and potential problems.
ENVIRONMENT
PGDATABASE
PGHOST
PGPORT
PGUSER Default connection parameters.
EXAMPLES
To clean the database test:
$ vacuumdb test
To clean and analyze for the optimizer a database named bigdb:
$ vacuumdb --analyze bigdb
To clean a single table foo in a database named xyzzy, and analyze a single column bar of the table for the optimizer:
$ vacuumdb --analyze --verbose --table 'foo(bar)' xyzzy
SEE ALSO
VACUUM [vacuum(7)]
Application 2002-11-22 VACUUMDB(1)