DROP EXTENSION(7) PostgreSQL 9.2.7 Documentation DROP EXTENSION(7)NAME
DROP_EXTENSION - remove an extension
SYNOPSIS
DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP EXTENSION removes extensions from the database. Dropping an extension causes its component objects to be dropped as well.
You must own the extension to use DROP EXTENSION.
PARAMETERS
IF EXISTS
Do not throw an error if the extension does not exist. A notice is issued in this case.
name
The name of an installed extension.
CASCADE
Automatically drop objects that depend on the extension.
RESTRICT
Refuse to drop the extension if any objects depend on it (other than its own member objects and other extensions listed in the same
DROP command). This is the default.
EXAMPLES
To remove the extension hstore from the current database:
DROP EXTENSION hstore;
This command will fail if any of hstore's objects are in use in the database, for example if any tables have columns of the hstore type.
Add the CASCADE option to forcibly remove those dependent objects as well.
COMPATIBILITY
DROP EXTENSION is a PostgreSQL extension.
SEE ALSO
CREATE EXTENSION (CREATE_EXTENSION(7)), ALTER EXTENSION (ALTER_EXTENSION(7))
PostgreSQL 9.2.7 2014-02-17 DROP EXTENSION(7)
Check Out this Related Man Page
DROP SCHEMA(7) PostgreSQL 9.2.7 Documentation DROP SCHEMA(7)NAME
DROP_SCHEMA - remove a schema
SYNOPSIS
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP SCHEMA removes schemas from the database.
A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even
if he does not own some of the objects within the schema.
PARAMETERS
IF EXISTS
Do not throw an error if the schema does not exist. A notice is issued in this case.
name
The name of a schema.
CASCADE
Automatically drop objects (tables, functions, etc.) that are contained in the schema.
RESTRICT
Refuse to drop the schema if it contains any objects. This is the default.
EXAMPLES
To remove schema mystuff from the database, along with everything it contains:
DROP SCHEMA mystuff CASCADE;
COMPATIBILITY
DROP SCHEMA is fully conforming with the SQL standard, except that the standard only allows one schema to be dropped per command, and apart
from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER SCHEMA (ALTER_SCHEMA(7)), CREATE SCHEMA (CREATE_SCHEMA(7))
PostgreSQL 9.2.7 2014-02-17 DROP SCHEMA(7)
How do you write a shell script that change the extension of all the files?
e.g
chext rtf doc
where .rtf is the original extension
and .doc is the new extension
is it something to do with basename?
do I need a for loop?
Please help!
Unix SuperNewbie (4 Replies)
Can anyone tell me the easiest way to append an extension (ie. .ldr) to all files in a directory that do NOT have an extension? The directory contains files with and without extensions, however I'm only interested in the files with NO extension.
Thanks. (3 Replies)
Hi,
I need a help regarding a small requirement. I have a list of C files. I need to put them in a file but without .c extension.
say if I have the files as file01.c, file02.c, file03.c etc
My file say cfiles should have
file01
file02
file03
...
...
etc
Appreciate your quick help on... (3 Replies)
Hi ALL,
I'm new to this forum.
Thanks and congrats to all for their great efforts building this site simply superb for all unix administrators.
My requirement is to remove extensions of the files in the current directory. I'm doing it using below script which is working but i think it is... (12 Replies)
Hi All,
i need to change the filename extension. For simplicity, we can assume that the extension after '.' is 3 characters only... but the filenames can vary.
eg. changing from abc.doc to abc.dxs
can i have a oneline command to achieve this (3 Replies)
Hi all.
I have a directory which contains files that can be versioned. All the files are named according to a pattern like this:
TEXTSTRING1-001.EXTENSION
TEXTSTRING2-001.EXTENSION
TEXTSTRING3-001.EXTENSION
...
TEXTSTRINGn-001.EXTENSION
If a file is versioned, a file called
... (10 Replies)
All,
I know that this will remove a file extension from a file name, but reading on the documentation on how it works confuses me.
${filename%.*}Can anyone explain what exactly is going on here? Filename is the pattern and % says to cut anything that starts with .?
Also, can I run this... (4 Replies)
HI ,
I have a file with multiple lines like below, I need to check on column starting with #prototype if it has the .Number.txt extension do nothing else add 1.txt extension.
Source data
Jdbc_app_data :- sample data
#prototype= sample data from test.1.txt
application_id=122135... (4 Replies)
what I'm trying to do is ... need to drop tables w/ names like
ABC_NY_2001
ABC_ORD_2001
ABC_TX_2001
ABC_CL_2001
For this, I want to write a query "DROP TABLE ABC_var_2001".
now "var" should be either NY, ORD, TX or CL.
I'm new to programming so don't know how to create a variable w/ OR... (3 Replies)
hi
I would like to ask if someone knows a command or a script on how to rename a multiple file in the directory starting at the end of the filename or at the .extension( i would like to remove the last 11 character before the extension) for example
Below is the result of my command ls inside... (5 Replies)
how can i remove numbers of characters from the last name of file with respect to not remove the files extension
example
VFX_Official_Trailer_(HD)__Shhh__-_by_Freddy_Chavez_Olmos_&_Shervin_Shoghian-.mp4
i want to rename this to
VFX-Official-Trailer-(HD)-Shhh... (13 Replies)
Hello,
I opened a file by accident (with a java program, which has been uninstalled!) and from then on, all the file with .fasta extension has been changed with an icon (So annoying!!) and the file attributes has been changed with the property:
Type: application/x-wine-extension-fasta type... (6 Replies)