DROP LANGUAGE(7) PostgreSQL 9.2.7 Documentation DROP LANGUAGE(7)NAME
DROP_LANGUAGE - remove a procedural language
DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]
DROP LANGUAGE removes the definition of a previously registered procedural language. You must be a superuser or the owner of the language
to use DROP LANGUAGE.
As of PostgreSQL 9.1, most procedural languages have been made into "extensions", and should therefore be removed with DROP EXTENSION
(DROP_EXTENSION(7)) not DROP LANGUAGE.
Do not throw an error if the language does not exist. A notice is issued in this case.
The name of an existing procedural language. For backward compatibility, the name can be enclosed by single quotes.
Automatically drop objects that depend on the language (such as functions in the language).
Refuse to drop the language if any objects depend on it. This is the default.
This command removes the procedural language plsample:
DROP LANGUAGE plsample;
There is no DROP LANGUAGE statement in the SQL standard.
ALTER LANGUAGE (ALTER_LANGUAGE(7)), CREATE LANGUAGE (CREATE_LANGUAGE(7)), droplang(1)PostgreSQL 9.2.7 2014-02-17 DROP LANGUAGE(7)
Check Out this Related Man Page
DROP SCHEMA(7) PostgreSQL 9.2.7 Documentation DROP SCHEMA(7)NAME
DROP_SCHEMA - remove a schema
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
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.
Do not throw an error if the schema does not exist. A notice is issued in this case.
The name of a schema.
Automatically drop objects (tables, functions, etc.) that are contained in the schema.
Refuse to drop the schema if it contains any objects. This is the default.
To remove schema mystuff from the database, along with everything it contains:
DROP SCHEMA mystuff CASCADE;
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.
ALTER SCHEMA (ALTER_SCHEMA(7)), CREATE SCHEMA (CREATE_SCHEMA(7))
PostgreSQL 9.2.7 2014-02-17 DROP SCHEMA(7)
I entered the command cat 401328 in an attempt to see a file. Now, my screen is displaying machine language. The properties of the file say that it is a postgres application. Is there a command I can enter so everything gets back to normal?
Thanks, (2 Replies)
I need to 'create' a new simple scripting language in order to allow SCADA operators make complex tasks against the system in an easy and friendly way.
In other words I need to write mini modules with DB readings or writings, calculations, and so on, but these instructions must be written... (2 Replies)
Here I want to calculate mean,variance and sum from a file
As this is a large file and i am trying to write in c
where formulae of
MEAN = 1/N (X1...+..Xn)
Variance = square root of 1/N-1... (9 Replies)
I'm wondering what methods and tools are used to describe procedural programs? Is UML suitable for such tasks? I've studied SDL in the university - we used it for specification of telecommunication services. Is it suitable for general description of procedural programs?
If not what... (2 Replies)
I need a small and simple clarification...
Can someone tell me whether PERL is a programming language or not.
Also, can shell scripts also considered as programming language or not.
Also, please tell me the exact difference between programming language and scripting.
Please help.... (3 Replies)
hi every body i want to know how can i know the default language in the hp-ux
like in solaris "US" please tell me wher is the file or the comand to tell me the language
---------- Post updated at 05:43 AM ---------- Previous update was at 05:05 AM ----------
crash:/#locale... (1 Reply)
What is extent of influence of C language? How essential is it in today's computer and IT technology? Do you think that the inventor of C language deserves more recognition than he appreciates now? (1 Reply)
Hi, I just bought a new mac and have been running a program out of terminal, but even early on I noticed that my single quotes looked a lot different from the ones used in all of the namelists and other files of the program. Specifically, mine are kind of slanted whereas the others are very... (7 Replies)