Hello Jean-Paul, I'm not a sqlt developer, but I use it fairly regularly with Pg. I just ran this command on my schema with about 100 tables:
sqlt-graph --from=PostgreSQL -o test.png nofuncs.sql and it worked fine (although it did make a really big picture, 1046x231 px). I suspect the parser is choking on something in your sql. I am pretty sure that the sqlt parser doesn't support functions and triggers, so if you have any of those, you should get them out. I don't know of any other problems, but that doesn't mean there aren't any. :-) Also, I am using version 0.08_04, which is what is currently in cvs. Scott On Tue, 2006-12-19 at 13:25 +0100, Jean-Paul Argudo wrote: > Hi all, > > In a recent project, Im looking for a nice tool that would graph in a > nice picture an entity/relation diagram of a PostgreSQL database, based > on a script (pg_dump --schema-only for example, but not only..) > > I found then sqlfairy. > > I use a debian sid, up-to-date, > > $ perl -v > This is perl, v5.8.8 built for i486-linux-gnu-thread-multi > > I installed libdbd-pgsql (and every dependance) > Installed : 0.7.1-3.1 > Candidate : 0.7.1-3.1 > > I found some problems in using sqlt-tools, since I was unable to find on > the net answers, I finaly report this to you, fellow hackers: > > (1) First, some strange things in the documentation > --------------------------------------------------- > > I had to read /usr/lib/perl5/DBD/Pg.pm to understand that the --dsn > option would need double-quoting this way: > > sqlt -f DBI --dsn "dbi:Pg:dbname=mydatabase;host=myservername" \ > --db-user dbuser --db-password test -t PostgreSQL > essai.sql > > As a PostgreSQL fan, I recognize the PQconnectdb-style of passing > parameters (see > http://www.postgresql.org/docs/8.2/interactive/libpq-connect.html). > > The MySQL example given in the perldoc of SQL::Translator::Manual doesnt > mention this: > > $ sqlt -f DBI --dsn dbi:mysql:FOO --db-user guest \ > --db-password p4ssw0rd -t PostgreSQL > foo > > > (2) A strange behaviour --from= and -f dont act the same? > ---------------------------------------------------------- > > [EMAIL PROTECTED]:/tmp$ sqlt-diagram --from=PostgreSQL -o test.png essai > Image written to 'test.png'. Done. > > [EMAIL PROTECTED]:/tmp$ sqlt-diagram -f PostgreSQL -o test.png essai > No db driver specified > Usage: > ./sqlt-diagram -d|-f|--from|--db=db_parser [options] schema.sql > [...] > > -f and --from= aren't suppose to be the same ? > > > (3) sqlt-diagram doesnt work well and sqlt-graph doesnt work at all... > ---------------------------------------------------------------------- > > ... on *my* system I guess... : > > [EMAIL PROTECTED]:/tmp$ sqlt-diagram --from=PostgreSQL -o test.png essai > Image written to 'test.png'. Done. > > [EMAIL PROTECTED]:/tmp$ kuickshow test.png > > --> I can see 10 tables out of 48 ... > > > [EMAIL PROTECTED]:/tmp$ sqlt-graph --from=PostgreSQL -o test.png essai > Undefined argument in option spec > Undefined argument in option spec > Undefined argument in option spec > > [EMAIL PROTECTED]:/tmp$ sqlt-graph --debug --from=PostgreSQL -o test.png essai > Undefined argument in option spec > Undefined argument in option spec > Undefined argument in option spec > > > --> I tried many options and stuff, Impossible to know how to use this > tool without > an error!! > > --> Im not Perl coder, just user of tools, I read docs (man and perldoc), > and howtos... no way > > Any help welcome ! > > -- > Jean-Paul Argudo > www.PostgreSQLFr.org > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV -- ------------------------------------------------------------------------ Scott Cain, Ph. D. [EMAIL PROTECTED] GMOD Coordinator (http://www.gmod.org/) 216-392-3087 Cold Spring Harbor Laboratory
signature.asc
Description: This is a digitally signed message part
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
-- sqlfairy-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
