DROP OWNED(7) SQL Commands DROP OWNED(7)NAME
DROP OWNED - remove database objects owned by a database role
SYNOPSIS
DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP OWNED drops all the objects in the current database that are owned by one of the specified roles. Any privileges granted to the given
roles on objects in the current database will also be revoked.
PARAMETERS
name The name of a role whose objects will be dropped, and whose privileges will be revoked.
CASCADE
Automatically drop objects that depend on the affected objects.
RESTRICT
Refuse to drop the objects owned by a role if any other database objects depend on one of the affected objects. This is the default.
NOTES
DROP OWNED is often used to prepare for the removal of one or more roles. Because DROP OWNED only affects the objects in the current data-
base, it is usually necessary to execute this command in each database that contains objects owned by a role that is to be removed.
Using the CASCADE option might make the command recurse to objects owned by other users.
The REASSIGN OWNED [reassign_owned(7)] command is an alternative that reassigns the ownership of all the database objects owned by one or
more roles.
COMPATIBILITY
The DROP OWNED statement is a PostgreSQL extension.
SEE ALSO
REASSIGN OWNED [reassign_owned(7)], DROP ROLE [drop_role(7)]
SQL - Language Statements 2010-05-14 DROP OWNED(7)
Check Out this Related Man Page
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)
I have a program which gets an input file (which contain a list of objects) and processes the objects one by one sequentially. However when there are many objects it is faster to split the input into smaller lists and run the program in multiple terminal sessions simultaneously. I want to know if... (2 Replies)
hi freinds,
can someone provide me a good link to unix make utility.
about make i only know that it plays a key role in sotware
development,as it helps in compilation and debugging.
thanks (1 Reply)
Hi everybody,
i need help from all of you.
I have many users who are no more work in our Company. Some who get objects are Locked. There Many users and many Database Servers. And it'll take long for me to finished this job.
That's why i need your help to provide me anyone Scripts... (2 Replies)
Hi,
I am trying to initialize fstream objects to NULL but its throwing an error.Could somebody tell me better way to do this.
I have code in C++ & compiling it using g++ compiler on a Linux box.
ifstream file;
file=NULL;
error
omega.cpp:38: error: no match for 'operator='... (4 Replies)
A recent job advertisement caught my attention, because I thought I was already broadly familiar with all the major OSes and database engines:
Apparently (according to Wikipedia), ADABAS is an 'inverted list database... described as "Post-relational" but "Relational Like" in its characteristics'... (4 Replies)
Hi,
I need a sample script to validate all the database objects like
1. table structure(columns, datatypes,key contraints if any)
2. synonyms
3. grants
4. indexes
....etc
thank you! (2 Replies)