09-10-2008
thanks gunzip -c is working
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i have this unix version "unix v/386" and i want to view the log files how i can do it?
regards (5 Replies)
Discussion started by: sak900354
5 Replies
2. Shell Programming and Scripting
Can some on say how in simplest way to implement the following:
I have two files:
1)
some
some
some
2)
another
another
another
I need to get third file:
3)
some another
some another
some another (1 Reply)
Discussion started by: mirusnet
1 Replies
3. UNIX for Dummies Questions & Answers
Hello All
I compressed a file hello by using compress command
compress hello ( enter )
i got the file as hello.z
1. My question is how can i see the file hello.z
2. How can i uncompress it back to change it to filename hello
thanks (4 Replies)
Discussion started by: supercops
4 Replies
4. OS X (Apple)
If you've come across this problem with unzipping/decompressing zips, you might find this helpful:
I was having a little trouble with unzipping (decompressing) tarred archives under OS 10.5 until today. My first attempt was to just simply double-click on the zip file (i.e., example.tar.gz) and... (2 Replies)
Discussion started by: unimachead
2 Replies
5. Solaris
If we have a zip file and we don't have enough space on the disk to unzip it but we want to be able to just read the file like if we can use cat without decompressing it. Is there a way we can do that? Like if we want
Thanks, (1 Reply)
Discussion started by: Pouchie1
1 Replies
6. Red Hat
I'm using tar and so far so good, but how can I view ALL files without having to fast forward and rewind the tape? Let's say I append 100 files onto the tape. Having to fast forward 100 times until I find the file I want is kinda tedious. (3 Replies)
Discussion started by: sdotsen
3 Replies
7. Shell Programming and Scripting
Hi,
Can you help me in providing me a command to view all files present in a directory.
Thanks a lot.
-Vamsi (1 Reply)
Discussion started by: VamsiVasili
1 Replies
8. Shell Programming and Scripting
Hi,
Can u provide me the command to view files in a directory.Urgent Pls.
-Vamsi (4 Replies)
Discussion started by: VamsiVasili
4 Replies
9. UNIX for Dummies Questions & Answers
Hello Team,
There is this situation where there are around 20 *.gz files and i want to search multiple words from all those files.
Example as below :
filea.gz
fileb.gz
filec.gz
now i want to search words "hi" and "hello" from all these 3 files without... (4 Replies)
Discussion started by: varun87
4 Replies
10. Fedora
My current Fedora version is 27. Desktop environment is LXDE. I am trying to view files sitting on my smartphone (Sony Xperia XA ultra) but it doesn't work anymore. This used to work before. I cannot view image and mp3 files but text files and pdf files work fine. When I move the files to the local... (3 Replies)
Discussion started by: milhan
3 Replies
LEARN ABOUT CENTOS
alter_view
ALTER
VIEW(7) PostgreSQL 9.2.7 Documentation ALTER VIEW(7)
NAME
ALTER_VIEW - change the definition of a view
SYNOPSIS
ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET DEFAULT expression
ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name DROP DEFAULT
ALTER VIEW [ IF EXISTS ] name OWNER TO new_owner
ALTER VIEW [ IF EXISTS ] name RENAME TO new_name
ALTER VIEW [ IF EXISTS ] name SET SCHEMA new_schema
ALTER VIEW [ IF EXISTS ] name SET ( view_option_name [= view_option_value] [, ... ] )
ALTER VIEW [ IF EXISTS ] name RESET ( view_option_name [, ... ] )
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.
IF EXISTS
Do not throw an error if the view does not exist. A notice is issued in this case.
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.
view_option_name
The name of a view option to be set or reset.
view_option_value
The new value for a view option.
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
equivalent 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))
PostgreSQL 9.2.7 2014-02-17 ALTER VIEW(7)