Category: How-To Guides

ALTER TABLE table_name OWNER TO new_owner; ALTER TABLE table_name RENAME TO new_name; ALTER TABLE table_name ADD column_name column_type; ALTER TABLE

unload (‘SELECT * from schemaname.tablename’)TO ‘s3://bucketname/filename’credentials ‘aws_access_key_id=XXXXXX;aws_secret_access_key=XXXXX’DELIMITER ‘|’allowoverwriteESCAPE; copy schemaname.tablenamefrom ‘s3://bucketname/filename’credentials ‘aws_access_key_id=XXXXXX;aws_secret_access_key=XXXXX’DELIMITER ‘|’ESCAPE;

CREATE USER username PASSWORD ‘password‘; CREATE USER username PASSWORD ‘password‘ CREATEDB; CREATE USER username PASSWORD ‘password‘ CREATEDB CREATEUSER; CREATE USER