Comments (2)
Hi @labasubagia,
You are correct that the current CLI cannot understand the default value of password_changed_at
column.
For now, you can try removing the ::timestamp with time zone
part to get it working. For example:
CREATE TABLE public.users (
username character varying NOT NULL,
hashed_password character varying NOT NULL,
full_name character varying NOT NULL,
email character varying NOT NULL,
password_changed_at timestamp with time zone DEFAULT '0001-01-01 00:00:00+00' NOT NULL,
created_at timestamp with time zone DEFAULT now() NOT NULL
);
We're working on improving the postgres->dbml exporter and hopefully will resolves this issue in the future.
from dbml.
Looking forward to it @NQPhuc
from dbml.
Related Issues (20)
- sql2dbml -- mssql parsing for defaults
- Enhancement request
- Another request for dbdiagram HOT 1
- Error with postgres GENERATED ALWAYS HOT 3
- Postgres: ALTER TABLE test ADD CONSTRAINT not converted to dbml HOT 1
- Add support for views HOT 2
- support of jsonb in postgresql HOT 2
- Implementing Generalization & specialization HOT 2
- [bug] incorrect table note parsing by dbml2sql HOT 2
- sql2dbml can not parse materialized views HOT 3
- Add support for gin indexes
- Website is down HOT 4
- How to have syntax highlighting on Intellij products? (WebStorm, etc.) HOT 5
- Unable to name constraints other than foreign keys HOT 1
- sql to dbml failed HOT 2
- add to monaco HOT 3
- Is there a UI that comes with the repo? HOT 1
- options for how dbml is exported HOT 1
- mssql ALTER TABLE HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbml.