[SQL] date problems

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/, and I'm no able to copy this table int

Re: [SQL] date problems

am Thu, dem 30.08.2007, um 15:01:03 +0200 mailte ivan marchesini folgendes: > 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 so

Re: [SQL] date problems

On Aug 30, 2007, at 8:01 , ivan marchesini wrote: a lot of table have some timestamp fields containing data as DD/MM/ , and I'm no able to copy this table into postgres... because it needs /MM/DD... I used \copy... The input and output formats of dates is controlled by the datestyle

Re: [SQL] date problems

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/, and I'm no

[SQL] Reporting functions (OLAP)

I am looking for reporting extensions such as windowing, ranking, leads/lags, etc. for postgresql. A quick google search turned up some "working on it" type results, but I was wondering if anything actually existed up to this point? Thanks, Sean ---(end of broadcast)-

[SQL] Software CASE - PostgreSQL

Hi ! What CASE tool may use with Postgresql? I need create MER diagram. I am a big problem with Erwin to create MER diagram of PostgreSQL. Thanks,. Eduardo ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating a