Login | Register
My pages Projects Community openCollabNet

Discussions > users > importing tables and schemas from postgresql

argouml-db
Discussion topic

Back to topic list

importing tables and schemas from postgresql

Author "David R dot Forrest" <drf5n at maplepark dot com>
Full name "David R dot Forrest" <drf5n at maplepark dot com>
Date 2007-12-12 14:07:35 PST
Message Hi,

I've been trying to work through the example using a pre-existing postgres
database and run into an error "Import failed. Problem retrieving metadata
for database
test: Column not found"

This box pops up at the Schema/import from catalog/import tables/(choose
table)/OK step.

I see these tables listed in the "Import Tables" box, as I expect
from my database:

drf@drf:~$ echo '\d\q' |psql test
              List of relations
  Schema | Name | Type | Owner
--------+-----------​--------+-------+---​----
  public | cursors | table | drf
  public | locations | table | drf
  public | pga_diagrams | table | drf
  public | pga_forms | table | drf
  public | pga_graphs | table | drf
  public | pga_images | table | drf
  public | pga_layout | table | drf
  public | pga_queries | table | drf
  public | pga_reports | table | drf
  public | pga_scripts | table | drf
  public | usarrests | table | drf
  public | vb_h2o_active_raw | table | drf
  public | x | table | drf
(13 rows)

Attached is a screenshot of the argouml.

I also got a similar error when I tried the database/Import from
Catalog/Import Schemas.

Has someone imported Schemas and Tables from postgres? I feel like the
connections & drivers are being made properly since it was able to list
the tables that I wanted to import. What should I try next?

Dave
--
  Dr. David Forrest
  drf at vims dot edu (804)684-7900w
  drf5n at maplepark dot com (804)642-0662h
                                    http://maplepark.com/~drf5n/
Attachments

« Previous message in topic | 1 of 7 | Next message in topic »

Messages

Show all messages in topic

importing tables and schemas from postgresql "David R dot Forrest" <drf5n at maplepark dot com> "David R dot Forrest" <drf5n at maplepark dot com> 2007-12-12 14:07:35 PST
     RE: importing tables and schemas from postgresql jgrengbondai Jules Grengbondai 2007-12-13 07:02:12 PST
         RE: importing tables and schemas from postgresql "David R dot Forrest" <drf5n at maplepark dot com> "David R dot Forrest" <drf5n at maplepark dot com> 2007-12-13 07:38:23 PST
             RE: RE: importing tables and schemas from postgresql jgrengbondai Jules Grengbondai 2007-12-13 08:24:55 PST
                 RE: RE: importing tables and schemas from postgresql "David R dot Forrest" <drf5n at maplepark dot com> "David R dot Forrest" <drf5n at maplepark dot com> 2007-12-13 11:27:39 PST
                     RE: RE: importing tables and schemas from postgresql "David R dot Forrest" <drf5n at maplepark dot com> "David R dot Forrest" <drf5n at maplepark dot com> 2007-12-13 13:08:09 PST
                         RE: RE: RE: importing tables and schemas from postgresql jgrengbondai Jules Grengbondai 2007-12-13 13:12:26 PST
Messages per page: