import psycopg2 as pg
import pandas.io.sql as psql
conn = pg.connect(database="abcd",user="postgres", password="xxxx")
df = pd.read_sql('SELECT * "xyz"', conn)
df.head()

DatabaseError: Execution failed on sql 'SELECT * "xyz"': syntax error at or near ""xyz""
LINE 1: SELECT * "trans"