Postgres Pro
Downloads
Home   >   mailing lists

Formatting time for INSERT INTO - Mailing list pgsql-general

From Rich Shepard
Subject Formatting time for INSERT INTO
Date
Msg-id alpine.LNX.2.00.1204251459010.18855@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Formatting time for INSERT INTO  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
Tree view 
   The table has a column 'coll_time' of type time without time zone. New
rows for the table are in a .sql file and the time values throw an error at
the colon between hours:minutes. Do time values need to be quoted?

TIA,

Rich

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: how robust are custom dumps?
Next
From: Ben Chobot
Date:
Subject: Re: Formatting time for INSERT INTO