Re: [SQL] Export Access 97 to PostgreSQL

Shavonne Marietta Wijesinghe escreveu: Hello I have a db in MS Access 97 and now i have to import the data in PostgreSQL. I can create the table structure in PostgreSql but in what format can i export the table from Access so Postgresql can read it? Thanks Shavonne Export the data, instea

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

Re: [SQL] Having the sum of two queries

Dani Castaños escreveu: ... And have the result of both added. I've tried something like SELECT tot.status, COUNT(total) Should be SELECT tot.status, SUM(total) FROM( QUERY A UNION QUERY B ) AS tot GROUP BY tot.status But it doesn't works. It doesn't add the total columns with the same s