I m trying to introspect an existing psql database Prisma is Prisma #orm-help

I'm trying to introspect an existing psql database...

Arnab

07/04/2018, 12:15 PM

I'm trying to introspect an existing psql database. Prisma is currently exclaiming that

Error: The provided database doesn't contain any tables. Please either provide another database or choose "No" for "Does your database contain existing data?"

. However, when I do

psql -h localhost -p 5430 -U <my_user> -p <my_password

and then

\dt

I can see lots of tables in my schema. Does it matter that the database in question has a few triggers and also is a bitemporal database?

nilan

07/04/2018, 12:18 PM

In which schema do these tables live?

Arnab

07/04/2018, 12:19 PM

they live in a schema called

myschema

Arnab

07/04/2018, 12:20 PM

meh I can just give you the real name.

Copy code

List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.utf8  | en_US.utf8  |
 template0 | postgres | UTF8     | en_US.utf8  | en_US.utf8  | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8  | en_US.utf8  | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 tff       | dba      | UTF8     | nb_NO.UTF-8 | nb_NO.UTF-8 |

nilan

07/04/2018, 12:20 PM

in the

prisma init

wizard, are you passing in the

myschema

when being asked for the schema?

Arnab

07/04/2018, 12:20 PM

yep

Arnab

07/04/2018, 12:20 PM

tff

in this case

nilan

07/04/2018, 12:21 PM

I think you experience this: https://github.com/prismagraphql/prisma/issues/2402

nilan

07/04/2018, 12:21 PM

we are fixing this soon 🙂

fast parrot 1

Arnab

07/04/2018, 12:21 PM

Yay!

divyendu

07/04/2018, 12:23 PM

You can also try the

prisma introspect

command to try and generate an introspected datamodel. If that also does not work, then the current workaround would be to rename your scheam to

public

👌 1

Open in Slack

Previous Next