Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Parsing mysqldump files

by 7stud (Deacon)
on Feb 25, 2013 at 03:47 UTC ( #1020451=note: print w/replies, xml ) Need Help??


in reply to Parsing mysqldump files

I also would be interested in a slick way of slurping this in without having to use some generic heavy-duty perl parser module.

Slurp::MindReader might be a good choice.

Numerical entries can be written as-is, while string entries are enclosed in single quotes. Single quotes within a string can be escaped with a backslash. Commas and parenthesis are treated as string characters when within a quoted string...Has anyone (parsed similar formats) before?

The format is called CSV. See Text::CSV_XS.

Replies are listed 'Best First'.
Re^2: Parsing mysqldump files
by Anonymous Monk on Feb 25, 2013 at 04:27 UTC
    ENOGOODATHUMOR

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1020451]
help
Chatterbox?
[erix]: if you're interested in tsv file reading in pg, look at file_fdw
[erix]: aka: create extension if not exists file_fdw;
[erix]: the annoying thing is that during setup of the 'foreign table' you have to specify all the columns. But that is reasonably automatable (just reading header line, and contruct the needed CREATE FOREIGN TABLE' statement)

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2018-02-23 15:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    When it is dark outside I am happiest to see ...














    Results (302 votes). Check out past polls.

    Notices?