Well, the insert works now, but the database keeps reverting to an old datestyle. Is there somewhere I can permanently change this?
warehouse=# show datestyle;
NOTICE: DateStyle is ISO with European conventions
SHOW VARIABLE
warehouse=# set datestyle to 'SQL, US';
SET VARIABLE
warehouse=# show datestyle;
NOTICE: DateStyle is SQL with US (NonEuropean) conventions
SHOW VARIABLE
warehouse=# \q
aaron@wmscentral:/var/www/frame$ psql warehouse
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
warehouse=# show datestyle;
NOTICE: DateStyle is ISO with European conventions
SHOW VARIABLE