12-29-2011
^ refers to start of input string. It will fetch only those lines that have ALTER TABLE at the beginning of line.
This User Gave Thanks to balajesuri For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I like to display 5 lines before and after find some keywork (i.e. error).
Thanks in advance (5 Replies)
Discussion started by: wangzosen
5 Replies
2. Shell Programming and Scripting
Hi,
How to cut all lines in file before keyword?
from
1 2333214 word ...... some text
2 234343 234234 word ...... some text
3 234324 324 3234 word ...... some text
to
1 2333214
2 234343 234234
3 234324 324 3234 (4 Replies)
Discussion started by: Trump
4 Replies
3. Shell Programming and Scripting
I am trying to delete key word starting with x in a unix text file.
example, I am trying to delete the words like xaa,xabxbb,xbd and so on....
my input file is some thing like this
xaaa w 1234 5678
rwsd ravi xw123
xbc3 ohrd
want to delete words xaaa,xw123 and xbc3 from the above... (10 Replies)
Discussion started by: rdhanek
10 Replies
4. Shell Programming and Scripting
I have my input sometyhing like this
aaa
bbbbbb cccccc
ddddd eeeee
1234 ravi kumar
aaaaaa vvvvvvv
5678 ravi kumar
rrrrrrr mmmmmmm
I want the output as follows.
aaa
bbbbbb cccccc
ddddd eeeee
1234 ravi kumar
aaaaaa vvvvvvv
5678 ravi kumar (2 Replies)
Discussion started by: rdhanek
2 Replies
5. Shell Programming and Scripting
I have my data something like this. I want to delete all the lines before the frist instance of the key word 'ravi kumar'
aaa
bbbbbb cccccc
ddddd eeeee
1234 ravi kumar
aaaaaa vvvvvvv
5678 ravi kumar
rrrrrrr mmmmmmm
I want the output as follows.
1234 ravi kumar
aaaaaa... (8 Replies)
Discussion started by: rdhanek
8 Replies
6. Shell Programming and Scripting
Hi,
I have a file such as:
---
>contig00001 length=35524 numreads=2944
gACGCCGCGCGCCGCGGCCAGGGCTGGCCCA
CAGGCCGCGCGGCGTCGGCTGGCTGAG
>contig00002 length=4242 numreads=43423
ATGCCGAAGGTCCGCCTGGGGCTGG
CGCCGGGAGCATGTAGCG
---
I would like to concatenate the lines not starting with ">"... (9 Replies)
Discussion started by: s052866
9 Replies
7. Shell Programming and Scripting
Hi ,
I have two files, say KEY_FILE and the MAIN_FILE. I am trying to read the KEY_FILE which has only one column and look for this column data in the MAIN_FILE to extract all the rows that have this key.
I have written a script to do so, but somehow it is not returning all the rows (
It... (4 Replies)
Discussion started by: Sheel
4 Replies
8. Shell Programming and Scripting
I have a text and I want to extract the 4 lines following a keyword!
For example if I have this text and the keyword is AAA
hello
helloo
AAA
one
two
three
four
helloooo
hellooo
I want the output to be
one
two
three
four (7 Replies)
Discussion started by: stekanius
7 Replies
9. UNIX for Dummies Questions & Answers
e.g.
File name: File.txt
cat File.txt
Result:
#INBOUND_QUEUE=FAQ1
INBOUND_QUEUE=FAQ2
I want to get the value for one which is not commented out.
Thanks, (3 Replies)
Discussion started by: Tanu
3 Replies
10. Shell Programming and Scripting
Hello ,
I will need your help once again.
I have the following file:
cat file02.txt
PATTERN XXX.YYY.ZZZ. 500
ROW01 aaa. 300 XS 14
ROW 45 29 AS XD.FD.
PATTERN 500 ZZYN002
ROW gdf gsste
ALT 267 fhhfe.ddgdg.
PATTERN ERE.MAY. 280
PATTERRNTH 5000 rt.rt.
ROW SO a 678
PATTERN... (2 Replies)
Discussion started by: alex2005
2 Replies
LEARN ABOUT SUSE
alter_view
ALTER
VIEW(7) SQL Commands ALTER VIEW(7)
NAME
ALTER VIEW - change the definition of a view
SYNOPSIS
ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression
ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT
ALTER VIEW name OWNER TO new_owner
ALTER VIEW name RENAME TO new_name
ALTER VIEW name SET SCHEMA new_schema
DESCRIPTION
ALTER VIEW changes various auxiliary properties of a view. (If you want to modify the view's defining query, use CREATE OR REPLACE VIEW.)
You must own the view to use ALTER VIEW. To change a view's schema, you must also have CREATE privilege on the new schema. To alter the
owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the view's schema.
(These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the view. However, a
superuser can alter ownership of any view anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing view.
SET/DROP DEFAULT
These forms set or remove the default value for a column. A default value associated with a view column is inserted into INSERT
statements on the view before the view's ON INSERT rule is applied, if the INSERT does not specify a value for the column.
new_owner
The user name of the new owner of the view.
new_name
The new name for the view.
new_schema
The new schema for the view.
NOTES
For historical reasons, ALTER TABLE can be used with views too; but the only variants of ALTER TABLE that are allowed with views are equiv-
alent to the ones shown above.
EXAMPLES
To rename the view foo to bar:
ALTER VIEW foo RENAME TO bar;
COMPATIBILITY
ALTER VIEW is a PostgreSQL extension of the SQL standard.
SEE ALSO
CREATE VIEW [create_view(7)], DROP VIEW [drop_view(7)]
SQL - Language Statements 2010-05-14 ALTER VIEW(7)