search

awsdocs / amazon-aurora-user-guide

The open source version of the Amazon Aurora User Guide. You can provide feedback by submitting issues in this repo, or propose changes by submitting a pull request.
Other
53 stars 102 forks source link

\gset not supported in Aurora engineVersion 10.11 #32

Closed itarano closed 2 years ago

itarano commented 3 years ago

Documentation: "To import from Amazon S3 into Aurora PostgreSQL, your database must be running PostgreSQL version 10.7 or later." and "psql=> SELECT aws_commons.create_s3_uri( 'sample-bucket', 'sample-filepath', 'us-west-2' ) AS s3_uri_1 \gset"

Problem: Invalid command \gset. Try \? for help.

itarano commented 2 years ago

Documentation url updated (master -> main)

ardentperf commented 2 years ago

I just did a quick test, and it worked for me:

aurora-10.11-2.4.4 rw root@db1=> SELECT 'hello' AS var1, 10 AS var2 \gset
Time: 0.488 ms

aurora-10.11-2.4.4 rw root@db1=> \echo :var1 :var2 
hello 10

Maybe check what version of the psql client you're using?

randyurbano commented 2 years ago

Thanks for the feedback. I'm closing this issue based on the previous comment.