Implementation of Date/Time Input Interpretation
in [PgSql]
|
From: Francis Markham on 22 Jun 2010 22:27 Thank you for your prompt reply. > What is it exactly that you are trying to accomplish? I want to be able to, from my own script, determine if postgres will be able to interpret a string as a date or time. If you can suggest a better way of accomplishing this beyond reimplementing your algorithm I would be happy to hear it! Cheers, Francis Markham On 23 June 2010 12:21, Dann Corbit <DCorbit(a)connx.com> wrote: > > From: pgsql-hackers-owner(a)postgresql.org [mailto:pgsql-hackers-owner(a)postgresql.org] On Behalf Of Francis Markham > Sent: Tuesday, June 22, 2010 7:13 PM > To: pgsql-hackers(a)postgresql.org > Subject: [HACKERS] Implementation of Date/Time Input Interpretation > > > > Greetings all, > > I am currently implementing a script to import data into postgres.� I would like to apply the algorithm to detect date and time values, outlined at http://developer.postgresql.org/pgdocs/postgres/datetime-input-rules.html > > However, I am unfamiliar (and somewhat intimidated) by the postgres source tree.� Would any kind person be able to point me to the source file(s) that implement the above algorithm? > >> > > You will find it under \src\backend\utils\adt\datetime.c > > To import data into postgres, I guess that reading the date time routine is probably not what you want to do. > > If you want to move the data in using a compiled program then use an ODBC driver. �PostgreSQL comes with a free one.� OLEDB is another sensible alternative.� Or JDBC if you want to use Java. > > If you want to bulk load lots of data at high speed, read up on the COPY command. > > If you just want to insert some rows using SQL, then simply perform an INSERT using PSQL� or some other interface of your choice. > > What is it exactly that you are trying to accomplish? > > << -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Andrew Dunstan on 22 Jun 2010 22:46 Francis Markham wrote: > Thank you for your prompt reply. > > >> What is it exactly that you are trying to accomplish? >> > > I want to be able to, from my own script, determine if postgres will > be able to interpret a string as a date or time. If you can suggest a > better way of accomplishing this beyond reimplementing your algorithm > I would be happy to hear it! > > Call the appropriate input function in plpgsql and trap a data exception? These routines are going to be quite hard to mimic, I suspect. Getting postgres to do the work for you is probably a better way to go if you can. cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
|
Pages: 1 Prev: Parallel pg_restore versus old dump files Next: [HACKERS] testing plpython3u on 9.0beta2 |