We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
I have a feature request:
When I do a "Script as Create" on a Postgres database table (ADS v1.47 with Postgres plugin v0.6.0), following statements are built:
In case a COMMENT was set on an table and/or a column, the following appropriate statements should additionally be built:
Further more (just guessing that its also missing here):
You can check the comment like this in Postgres:
-- check comment on table myschema."MyTable": SELECT obj_description('myschema."MyTable"'::regclass); -- check comment on column "MyColumn" on table myschema."MyTable": SELECT col_description('myschema."MyTable"'::regclass::oid, (SELECT attnum FROM pg_attribute WHERE attrelid = 'myschema."MyTable"'::regclass AND attname = 'MyColumn'));
The text was updated successfully, but these errors were encountered:
@FrySlim - what PG version are you working with?
Sorry, something went wrong.
At least PG 11 and newer.
samir-puranik
No branches or pull requests
I have a feature request:
When I do a "Script as Create" on a Postgres database table (ADS v1.47 with Postgres plugin v0.6.0), following statements are built:
In case a COMMENT was set on an table and/or a column, the following appropriate statements should additionally be built:
Further more (just guessing that its also missing here):
You can check the comment like this in Postgres:
-- check comment on table myschema."MyTable":
SELECT obj_description('myschema."MyTable"'::regclass);
-- check comment on column "MyColumn" on table myschema."MyTable":
SELECT col_description('myschema."MyTable"'::regclass::oid, (SELECT attnum FROM pg_attribute WHERE attrelid = 'myschema."MyTable"'::regclass AND attname = 'MyColumn'));
The text was updated successfully, but these errors were encountered: