Hi.
I've posted a couple of questions on my little project before, and it's been helpful, but things just keep changing on my end.
Allow me to explain.
I'm getting hundreds of .txt files, each containing the results of a database search from a newspaper. EAch file contains the news stories... (10 Replies)
Hai masters,
Suppose i have so many files named xxxx.ksh.tar, yyyy.ksh.tar and so on.
My requirement : i want to rename all the files with extension ".ksh.tar" to ".tar" in my directory.
Could you please tell me the solution for this.. (5 Replies)
have this shl that will FTP a file from the a directory in windows to UNIX, It get the name of the file stored in this variable $UpLoadFileName then put in the local directory LocalDir="${MPATH}/xxxxx/dat_files" that part seems to be working, but then I need to take that file and rename, I am using... (3 Replies)
I have to rename a large number of files so that the name of each file corresponds to a code number that is given side by side in a list (textfile).
The list contains in column A the filename of the actual files to be renamed and in column B the name (a client code, 9 digits) that has to be... (7 Replies)
Hey folks
My problem is simple. For my first stash of movies, I used a naming convention of YEAR_MOVIE_NAME__QUALITY/ for each movie folder. For example, if I had a 1080p print of Minority Report, it would be 2002_Minority_Report__1080p/.
The 2nd time around, I changed the naming convention... (4 Replies)
Hi all,
I created file like this
AAb.lol
AAc.lol
AAx.lol
test.sh
My goal is to create a script (test.sh) which renames all the files to their original name without AA. I want to end up with this:
b.lol
c.lol
x.lol
Using sed how is it possible?
i tried to write the script
... (3 Replies)
hi,
I have a directory "test" under which there are 3 files a.txt,b.txt and c.txt.
I need to rename those files to a.pl,b.pl and c.pl respectively.
is it possible to achieve this in a sed or awk one liner?
i have searched but many of them are scripts.
I need to do this in a one liner.
I... (2 Replies)
Hi there,
I have 350 files in this directory: /home/adams/29 that was mistakenly renamed in this format:
TTFILE_BIT_638478.txt.dat
I want to take out the trailing .dat so that it ends in .txt: TTFILE_BIT_638478.txt
I need help please.
Thank you. (6 Replies)
Hi
Am trying to move a file from one name to another
When I do "ls" to check for the moved filename
I can see the file but when I try the same with a script am unable..
I think am doing some pretty silly error.. please help..
toMove=`ls | grep -E "partition.+"`
mv $toMove partition._org... (7 Replies)
Hi guys,
I have written a code to move my file from one directory to another directory, the file is in .csv format and i need to append a current date to the file. the prolem is date is getting appended after the file extension..
here is my code :
cd /data/home/abc/xyz
now=$(date... (7 Replies)
Discussion started by: azherkn3
7 Replies
LEARN ABOUT REDHAT
drop_index
DROP INDEX(7) SQL Commands DROP INDEX(7)NAME
DROP INDEX - remove an index
SYNOPSIS
DROP INDEX index_name [, ...] [ CASCADE | RESTRICT ]
INPUTS
index_name
The name (optionally schema-qualified) of an index to remove.
CASCADE
Automatically drop objects that depend on the index.
RESTRICT
Refuse to drop the index if there are any dependent objects. This is the default.
OUTPUTS
DROP INDEX
The message returned if the command completes successfully.
ERROR: index "index_name" does not exist
This message occurs if index_name is not an index in the database.
DESCRIPTION
DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.
NOTES
DROP INDEX is a PostgreSQL language extension.
Refer to CREATE INDEX [create_index(7)] for information on how to create indexes.
USAGE
This command will remove the title_idx index:
DROP INDEX title_idx;
COMPATIBILITY
SQL92
SQL92 defines commands by which to access a generic relational database. Indexes are an implementation-dependent feature and hence there
are no index-specific commands or definitions in the SQL92 language.
SQL - Language Statements 2002-11-22 DROP INDEX(7)