About String manipulation [closed]

1

I have a somewhat curious problem, maybe a challenge.

I need to add to my database the list of all cities in Brazil, I found a SQL with all the way I need it, however, the name of the SQL table is with "quotation marks" as in the following example:

INSERT INTO 'tb_cidades' VALUES (0001, 01, 'AC', 'Acrelandia');
INSERT INTO 'tb_cidades' VALUES (0002, 01, 'AC', 'Assis Brasil');
INSERT INTO 'tb_cidades' VALUES (0003, 01, 'AC', 'Brasileia');
INSERT INTO 'tb_cidades' VALUES (0004, 01, 'AC', 'Bujari');
INSERT INTO 'tb_cidades' VALUES (0005, 01, 'AC', 'Capixaba');

I would like to know, as I do to create a simple script or algorithm, to change the name 'tb_cidades' to cities. I have the list with all, only in a .txt file

    
asked by anonymous 22.02.2017 / 20:12

1 answer

0

I had the same problem recently, I generated a script with the information entered in my old Firebird database to add to PostgreSQL, but the date information came without the quotes, the solution they suggested and it worked. notepad ++ and gave worked perfectly for me I believe it works for you too:

Link for my question

    
22.02.2017 / 20:19