Can I request AWS Redshift with the PHP PDO Postgres driver?

Question

I can not find information about this on the Amazon website, but is this possible?

Answer 1

Of course you can,

I am using PHP PostgreSQL to query AWS Redshift

Answer 2

For those looking for examples:

$connection = new PDO(
    'pgsql:dbname=<db_name>;host=<redshift_cluster_host>;port=5439',
    '<master_user_name>', 
    '<master_user_password>'
);

$statement = $connection->prepare('<your_query>');
$statement->execute();
$result = $statement->fetch();

Also, make sure that you correctly configured the cluster security groups (on the Security tab in the AWS Redshift administrator).