Is it possible to query AWS Redshift with PHP's PDO Postgres driver?

Question

I can't find any information relating to this on Amazon's site, but is this possible?

Answer 1

Sure you can,

I am using PHP PostgreSQL to query AWS Redshift

Answer 2

For those who are 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, ensure you configured your cluster security groups correctly (under Security tab in the AWS Redshift admin).