From: Roberto Spier <roberto.spier@conab.gov.br>
To: marchesini@unipg.it
Cc: pgsql-sql@postgresql.org
Subject: Re: date problems
Date: Thu, 30 Aug 2007 15:31:52 -0300
Message-ID: <46D70D18.5060501@conab.gov.br> (raw)
In-Reply-To: <1188478863.4876.23.camel@ivangeo>
References: <1188478863.4876.23.camel@ivangeo>
ivan marchesini escreveu:
> Dear PG users,
> I have an access db and I'm trying to pass all to postgres
> I have used mdbtools to export the schema and all went quite well.
> then I exported the single tables... to csv..
>
> a lot of table have some timestamp fields containing data as DD/MM/YYYY,
> and I'm no able to copy this table into postgres... because it needs
> YYYY/MM/DD...
> I used \copy...
>
> Which is the best solution for this problem...
>
> many thanks
>
> Ivan
>
>
another approach:
from within your access .mdb file, connect your new pg tables through
ODBC. Then execute an INSERT INTO pg_table(...) SELECT ... FROM acc_table;
spier
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: roberto.spier@conab.gov.br, marchesini@unipg.it
Subject: Re: date problems
In-Reply-To: <46D70D18.5060501@conab.gov.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox