Ask Your Question
4

How can table name be passed as an argument in psycopg2?

asked 2021-08-01 11:00:00 +0000

devzero gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2022-06-13 12:00:00 +0000

lakamha gravatar image

To pass a table name as an argument in psycopg2, you can use parameterized queries. Here is an example:

import psycopg2

table_name = 'my_table'

conn = psycopg2.connect(dbname='my_database', user='my_user', password='my_password', host='my_host')
cursor = conn.cursor()

query = """
    SELECT * FROM %s;
"""

cursor.execute(query, (table_name,))

result = cursor.fetchall()

conn.close()

In this example, the table name is stored in a variable called table_name, which is then passed as an argument to the parameterized query using %s. The actual value of table_name is provided as a parameter to the execute() method, along with any other parameters that the query might require.

Note that it is important to use parameterized queries instead of string concatenation to build your queries, in order to prevent SQL injection attacks.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-08-01 11:00:00 +0000

Seen: 17 times

Last updated: Jun 13 '22