Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

drop_extension(7) [centos man page]

EXTENSION(7) PostgreSQL 9.2.7 Documentation DROP EXTENSION(7) NAME
DROP_EXTENSION - remove an extension SYNOPSIS
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

Check Out this Related Man Page

TABLE(7) PostgreSQL 9.2.7 Documentation DROP FOREIGN TABLE(7) NAME
DROP_FOREIGN_TABLE - remove a foreign table SYNOPSIS
DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it. PARAMETERS
IF EXISTS Do not throw an error if the foreign table does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the foreign table to drop. CASCADE Automatically drop objects that depend on the foreign table (such as views). RESTRICT Refuse to drop the foreign table if any objects depend on it. This is the default. EXAMPLES
To destroy two foreign tables, films and distributors: DROP FOREIGN TABLE films, distributors; COMPATIBILITY
This command conforms to the ISO/IEC 9075-9 (SQL/MED), except that the standard only allows one foreign table to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL extension. SEE ALSO
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to change extension?

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)
Discussion started by: prkwan
4 Replies

2. Shell Programming and Scripting

Append extension

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)
Discussion started by: here2learn
3 Replies

3. UNIX for Dummies Questions & Answers

without extension

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)
Discussion started by: adurga
3 Replies

4. Shell Programming and Scripting

remove file extension

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)
Discussion started by: prvnrk
12 Replies

5. HP-UX

file with ".r" extension

hi How to open/view a file with .r extension? (3 Replies)
Discussion started by: rakshit
3 Replies

6. Shell Programming and Scripting

changing filename extension

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)
Discussion started by: Hiso
3 Replies

7. Shell Programming and Scripting

Reading extension of files

Hi, I need a command to read extension of files. Could anyone please help me? (14 Replies)
Discussion started by: priyadarshini
14 Replies

8. UNIX for Dummies Questions & Answers

About the file extension

Hi everyone, Can we know that which type of file is there without opening a file thanks in advance.... kunal patil (3 Replies)
Discussion started by: kunalpatil09
3 Replies

9. Shell Programming and Scripting

Finding consecutive numbers in version names on a txt file

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)
Discussion started by: fox1212
10 Replies

10. Shell Programming and Scripting

Removal of file extension question

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)
Discussion started by: markdjones82
4 Replies

11. Shell Programming and Scripting

Adding the data before file extension

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)
Discussion started by: gaur.deepti
4 Replies

12. Shell Programming and Scripting

how to Declare 5 values to one variable with OR operation

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)
Discussion started by: ramsowji
3 Replies

13. Shell Programming and Scripting

removing a word in a multiple file starting at the dot extension

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)
Discussion started by: jao_madn
5 Replies

14. Shell Programming and Scripting

Remove the last 15 characters of a filename with respect to leave file extension

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)
Discussion started by: ateya
13 Replies

15. UNIX for Dummies Questions & Answers

How to remove attributes of a file?

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)
Discussion started by: yifangt
6 Replies

Featured Tech Videos