search

awsdocs / amazon-redshift-developer-guide

This is the documentation for the Amazon Redshift Developer Guide
Other
121 stars 143 forks source link

Update PG_GET_COLS.md #43

Closed eduardowillame closed 1 year ago

eduardowillame commented 3 years ago

When we run "select pg_get_cols('sales_vw');" the output type is RECORD, not VARCHAR as it is not possible to any string function to handle the output. The output for the second query in the example seems to be VARCHAR: select * from pg_get_cols('sales_vw') cols(view_schema name, view_name name, col_name name, col_type varchar, col_num int);

Issue #, if available:

Description of changes:

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of your choice.

joshbean commented 1 year ago

Closing this issue or pull request in advance of archiving this repo. For more information about the decision to archive this repo (and others in the 'awsdocs' org), see the announcement on the AWS News Blog.