Hi All,
What’s the best way to create a postgres subtable? In theory I think I could do a and
But, you can’t have an empty element. What’s the best thing to do here? Custom SQL? Any plans for supporting this?
Thanks!
Hi All,
What’s the best way to create a postgres subtable? In theory I think I could do a and
But, you can’t have an empty element. What’s the best thing to do here? Custom SQL? Any plans for supporting this?
Thanks!
We probably won’t support it in the core liquibase product because it is so postgres specific. You could create an extension for it (or add to the postgres-specific extension library). See http://liquibase.org/extensions for more information on that.
Otherwise, you’ll have to use the tag.
Nathan
Okay, thanks for the response. It would work if the column element were optional. Not sure what the ANSI SQL standard says about zero-column tables, but postgres allows it: create table foo(). I understand it’s a low priority in any case.