(no subject)

[nolly]

Any Postgres experts in the house?

I need to do CREATE TABLE ... (LIKE ...) or the equivalent, but I want the new table to have the permissions/priveleges (and, ideally, indexes) of the table it's modelled on. Any tips?

Comments

sneaky way

[tkil.livejournal.com]

If it's not provided for in the DDL directly, you could always export the table definitions as DDL, change the names, and then execute that.

But I don't know PostgreSQL well enough to offer any further hints. :(