EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Data Science Data Science Tutorials PostgreSQL Tutorial PostgreSQL EXECUTE

PostgreSQL EXECUTE

Priya Pedamkar
Article byPriya Pedamkar

Updated May 22, 2023

PostgreSQL EXECUTE

Introduction to PostgreSQL EXECUTE

PostgreSQL EXECUTE statement is used to execute the previously created prepared statement, to execute that statement using execute the command, we need to give the name of the prepared statement and the parameter. Prepare statement in PostgreSQL only exist duration of the current session we have used, after session disconnection prepare statement will automatically remove from the database server. We can use the execute command in the prepared statement to select, delete, and insert statement.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Syntax:

Below is the syntax :

Execute (name of prepared statement) [(parameter)]

Parameter

Below is the parameter description syntax of EXECUTE statement in PostgreSQL:

  • Execute: This statement is used to execute the prepared statement in PostgreSQL.
  • Name: This is defined as the prepared statement used with execute statement in PostgreSQL.
  • Parameter: This is defined as actual value of the parameter prepared statement. This data type value was compatible with the parameter of prepared statement in PostgreSQL.

How PostgreSQL EXECUTE Statement works?

Below is the working of EXECUTE statement :

  • We must first create a prepared statement to use the execute statement in PostgreSQL. Without creating a prepared statement, we cannot use the complete statement.
  • It will return the syntax error while executing the statement.

In the below example, we need first to create a prepared statement.

Code:

EXECUTE exe_test(1, 'ABC', 'Mumbai');
PREPARE exe_test (int, text, text) AS INSERT INTO exe_test VALUES($1, $2, $3);
EXECUTE exe_test(1, 'ABC', 'Mumbai');
select * from exe_test;

Output:

PostgreSQL EXECUTE 1

  • In the above first line of code, we used to execute the statement with the exe_test prepare statement, but it will show the error.
  • So we need to create the prepared statement to use the execute statement.
  • In the second line of code, we have successfully executed the execute statement because, with this statement, we have used a prepared statement.
  • We created the prepared statement name as exe_test after creating the same one we used in execute the statement.

In the next example, we will see the prepare statement is only valid in the current session, which we have connected, after disconnecting from the session prepare statement is automatically removed from the database server.

Code:

PREPARE exe_test (int, text, text) AS INSERT INTO exe_test VALUES($1, $2, $3);
EXECUTE exe_test(1, 'ABC', 'Mumbai');
select * from exe_test;
psql -U postgres
EXECUTE exe_test(1, 'ABC', 'Mumbai');

Output:

PostgreSQL EXECEUTE 2

  • In the above code, we have created a prepared statement name as exe_test after creating the same, we have use this using execute the statement.
  • After executing this, we have disconnected from the session and are again trying to log in with the same user credentials.
  • By following the above steps, we have again connected to the session, but the prepared statement will not exist into the database because it will automatically delete from the server after disconnecting from the current session.

Examples of PostgreSQL EXECUTE

Given below are the examples mentioned :

Example #1

Insert data into the table by using execute statement.

Below example shows how to insert the data into the table by using execute statement in PostgreSQL.

  • In the example, we first created a prepared statement name as exe_test.
  • Using this prepared statement, we execute the command and insert data or rows into the exe_test table.

Code:

PREPARE exe_test (int, text, text) AS INSERT INTO exe_test VALUES($1, $2, $3);
EXECUTE exe_test(2, 'PQR', 'Delhi');
EXECUTE exe_test(3, 'XYZ', 'Pune');
select * from exe_test;

Output:

Insert data into the table

Example #2

Select data from the table by using execute statement.

Below example shows how to select the data from the table by using execute statement in PostgreSQL.

  • In the example, we have created a prepared statement name as exe_test1. Using this prepared statement, we select the data from the exe_test table using execute the command.

Code:

PREPARE exe_test1 (int, text, text) AS SELECT id, name, address FROM exe_test;
EXECUTE exe_test1(1, 'ABC', 'Mumbai');

Output:

Select data from the table

Example #3

Delete data from the table by using execute statement.

Below example shows how to delete the data from the table by using execute statement in PostgreSQL.

  • In the example, we have created a prepared statement name as exe_test2. Using this prepared statement, we are deleting the data from the exe_test table by using execute the command.

Code:

PREPARE exe_test2 (int) AS delete from exe_test where id =1;
EXECUTE exe_test2(1);
select * from exe_test;

Output:

Delete data

Recommended Articles

We hope that this EDUCBA information on “PostgreSQL EXECUTE” was beneficial to you. You can view EDUCBA’s recommended articles for more information.

  1. PostgreSQL Average
  2. Transaction in PostgreSQL
  3. PostgreSQL UNIQUE Index
  4. PostgreSQL CTE
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
CYBER SECURITY & ETHICAL HACKING Course Bundle - 13 Courses in 1 | 3 Mock Tests
64+ Hours of HD Videos
13 Courses
3 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
MICROSOFT AZURE Course Bundle - 15 Courses in 1 | 12 Mock Tests
62+ Hour of HD Videos
15 Courses
12 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
KALI LINUX Course Bundle - 6 Courses in 1
20+ Hours of HD Videos
6 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
Primary Sidebar
Popular Course in this category
POSTGRESQL Course Bundle - 5 Courses in 1 | 1 Mock Test
 15+ Hour of HD Videos
5 Courses
1 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.5
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more