If you're running from the sql editor, then - you have either of the two options:
Set search_path = 'teleon, public';
CREATE TABLE...
Or,
Specify the schema in front of tge type.
-- Thanks, Ashesh
Will have a go at it. However, for those of us less pg-aware folks, it seems strange that running the script in psql works versus in pgdmin4. As far as i know, this worked on a prior pgAdmin4 release when I was running on Windows 10, not Ubuntu.
Will have a go at it. However, for those of us less pg-aware folks, it seems strange that running the script in psql works versus in pgdmin4. As far as i know, this worked on a prior pgAdmin4 release when I was running on Windows 10, not Ubuntu.
It also works fine if I execute the same scripts from within pgmodeler (which is where I cut the source from originally).
I am a bit wary about setting the path, I have multiple schemas.
Not a biggie for me at the moment, it was just a quick fix to test things out prior to doing a full pgmodeler DB rebuild and reload.