Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3FFE29FB520 for ; Thu, 30 Aug 2007 10:18:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 76991-10 for ; Thu, 30 Aug 2007 10:18:06 -0300 (ADT) X-Greylist: delayed 00:23:53.679083 by SQLgrey-1.7.5 Received: from trabant.cianoz.org (host31-194-149-62.serverdedicati.aruba.it [62.149.194.31]) by postgresql.org (Postfix) with ESMTP id D56ED9FB664 for ; Thu, 30 Aug 2007 10:18:13 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by trabant.cianoz.org (Postfix) with ESMTP id 7075F38420F for ; Thu, 30 Aug 2007 14:54:16 +0200 (CEST) X-Virus-Scanned: by amavisd-new at actionlinesrl.it Received: from trabant.cianoz.org ([127.0.0.1]) by localhost (mail.actionlinesrl.it [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0AUVAyzrwqFD for ; Thu, 30 Aug 2007 14:54:06 +0200 (CEST) Received: from [141.250.41.212] (unknown [141.250.41.212]) by trabant.cianoz.org (Postfix) with ESMTP id D098438420D for ; Thu, 30 Aug 2007 14:54:06 +0200 (CEST) Subject: date problems From: ivan marchesini Reply-To: marchesini@unipg.it To: pgsql-sql@postgresql.org Content-Type: text/plain Organization: University of Perugia Date: Thu, 30 Aug 2007 15:01:03 +0200 Message-Id: <1188478863.4876.23.camel@ivangeo> Mime-Version: 1.0 X-Mailer: Evolution 2.10.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/253 X-Sequence-Number: 29191 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 -- Ti prego di cercare di non inviarmi files .doc, .xls, .ppt, .dwg. Preferisco formati liberi. Please try to avoid to send me .doc, .xls, .ppt, .dwg files. I prefer free formats. http://it.wikipedia.org/wiki/Formato_aperto http://en.wikipedia.org/wiki/Open_format Ivan Marchesini Department of Civil and Environmental Engineering University of Perugia Via G. Duranti 93/a 06125 Perugia (Italy) e-mail: marchesini@unipg.it ivan.marchesini@gmail.com tel: +39(0)755853760 fax (university): +39(0)755853756 fax (home): +39(0)5782830887 jabber: geoivan73@jabber.org