如何重命名现有表？基于Declarative Base动态创建200+表的代码实现

Hey there! Let's break down how to rename your table in PostgreSQL using SQLAlchemy, and also clear up a quick note about your 200+ tables goal since that's part of your context.

Direct SQL Approach (Simple & Straightforward) #

The easiest way to rename a table in PostgreSQL is using the native ALTER TABLE command. You can execute this directly via SQLAlchemy's session:

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

# Configure your database connection (update with your actual credentials)
engine = create_engine("postgresql://your_user:your_password@your_host/your_db")
Session = sessionmaker(bind=engine)
session = Session()

# Execute the rename command
session.execute("ALTER TABLE titanic RENAME TO wild")
session.commit()  # Don't forget to commit the change to make it permanent!
session.close()

SQLAlchemy Core Approach (ORM-Friendly) #

If you prefer using SQLAlchemy's core API instead of raw SQL, you can reflect the existing table and use the built-in rename() method:

from sqlalchemy import MetaData, Table

metadata = MetaData()
# Reflect the existing "titanic" table from your database
titanic_table = Table("titanic", metadata, autoload_with=engine)

# Rename the table to "wild"
titanic_table.rename("wild")

# Apply the change to the database
metadata.create_all(engine)

A Quick Heads-Up for Your 200+ Tables Goal #

Wait a second—if you're trying to create 200+ tables with the same structure, renaming won't generate new tables (it just changes the name of an existing one). Instead, you should create a template table first (your Movie class mapped to titanic), then copy its structure to new empty tables in bulk:

# First, create your template table (run this once)
Base.metadata.create_all(engine)

# List of 200+ table names you want to create
new_table_names = ["wild", "avatar", "inception", ...]  # Add all your target table names here

session = Session()
for table_name in new_table_names:
    # Create a new empty table with the exact same structure as "titanic"
    session.execute(f"CREATE TABLE {table_name} AS SELECT * FROM titanic WHERE 1=0;")
session.commit()
session.close()

This way, you'll end up with 200+ separate tables, all matching the structure of your original Movie class.

内容的提问来源于stack exchange，提问作者revoltman