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 status... ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
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 able to copy this table into postgres... because it needs /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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
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, instead! You'd connect (link) to the postgreSQL database from within access mdb, then run an acc's INSERT INTO query. hth -- Spier -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
