[This topic is migrated from our old forums. The original author name has been removed]
When viewing or scripting the DDL of a PostgreSQL table or index, the tablespace is not included, but it is shown in the index details.
Including this makes altering the object from a Script Object to SQL Editor much easier:
CREATE INDEX __indexname__
ON __tablename__
(
col1
)
TABLESPACE __tablespacename___
1 Comment
Hans Bergsten
said
about 12 years ago
[This reply is migrated from our old forums.]
Re: Include tablespace on PostgreSQL DDL
Hi Matt,
Thanks for the suggestion. I've opened a ticket for this.
Best Regards,
Hans
anonymous