DO(7) PostgreSQL 9.2.7 Documentation DO(7)NAME
DO - execute an anonymous code block
SYNOPSIS
DO [ LANGUAGE lang_name ] code
DESCRIPTION
DO executes an anonymous code block, or in other words a transient anonymous function in a procedural language.
The code block is treated as though it were the body of a function with no parameters, returning void. It is parsed and executed a single
time.
The optional LANGUAGE clause can be written either before or after the code block.
PARAMETERS
code
The procedural language code to be executed. This must be specified as a string literal, just as in CREATE FUNCTION. Use of a
dollar-quoted literal is recommended.
lang_name
The name of the procedural language the code is written in. If omitted, the default is plpgsql.
NOTES
The procedural language to be used must already have been installed into the current database by means of CREATE LANGUAGE. plpgsql is
installed by default, but other languages are not.
The user must have USAGE privilege for the procedural language, or must be a superuser if the language is untrusted. This is the same
privilege requirement as for creating a function in the language.
EXAMPLES
Grant all privileges on all views in schema public to role webuser:
DO $$DECLARE r record;
BEGIN
FOR r IN SELECT table_schema, table_name FROM information_schema.tables
WHERE table_type = 'VIEW' AND table_schema = 'public'
LOOP
EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser';
END LOOP;
END$$;
COMPATIBILITY
There is no DO statement in the SQL standard.
SEE ALSO
CREATE LANGUAGE (CREATE_LANGUAGE(7))
PostgreSQL 9.2.7 2014-02-17 DO(7)
Check Out this Related Man Page
DROP LANGUAGE(7) SQL Commands DROP LANGUAGE(7)NAME
DROP LANGUAGE - remove a user-defined procedural language
SYNOPSIS
DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]
INPUTS
name The name of an existing procedural language. For backward compatibility, the name may be enclosed by single quotes.
CASCADE
Automatically drop objects that depend on the language (such as functions in the language).
RESTRICT
Refuse to drop the language if there are any dependent objects. This is the default.
OUTPUTS
DROP LANGUAGE
This message is returned if the language is successfully dropped.
ERROR: Language "name" doesn't exist
This message occurs if a language called name is not found in the database.
DESCRIPTION
DROP PROCEDURAL LANGUAGE will remove the definition of the previously registered procedural language called name.
NOTES
The DROP PROCEDURAL LANGUAGE statement is a PostgreSQL language extension.
Refer to CREATE LANGUAGE [create_language(7)] for information on how to create procedural languages.
USAGE
This command removes the PL/Sample language:
DROP LANGUAGE plsample;
COMPATIBILITY
SQL92
There is no DROP PROCEDURAL LANGUAGE in SQL92.
SQL - Language Statements 2002-11-22 DROP LANGUAGE(7)
QUERY SCENARIO
Here is the actual scenario
LOOP
echo "$COLNAME $TYPENAME($LENGTH) $NULLS ">>$DDL_FILE
END-LOOP
COLNAME, TYPENAME, LENGTH, NULLS are the variables and within echo statment the output of which has to go into file specified by DDL_FILE.
... (1 Reply)
Hello,
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)
Hello All,
I would like to know and understand the difference between the below 3 IF loops and also if possible what are the different other parameters i could use other than those mentioed in the below lF LOOP conditions, appreciate your help.
Thanks,
Sam. (1 Reply)
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
many thanks
---------- Post updated at 05:43 AM ---------- Previous update was at 05:05 AM ----------
crash:/#locale... (1 Reply)
Hi,
I've a requirement where I want to re-assign the value in the variable through which FOR LOOP loops.
For e.g.
Snippet of code
---------------
for i in $var
do
echo $i >> $tempFile
var=`echo $another_var | awk -F" " '{print $1}'`
done
I am re-assigning var so... (2 Replies)
I'am writing a program in C language and my code is working perfectly i just need to add a search to it ...
My code lets users add companies, and then display them on screen...
i would like to add a search that allows user to type company name and then displayall its info on the screen !!
THANK... (1 Reply)