You need to select the database before creating a table with the powerDesinger tool. After determining the database type and version, you can’t Do database conversion again, unless you re-create a
Month: September 2021
PowerDesigner generates an HTML document
Using PowerDesinger to produce HTML documents, it is convenient to query the detailed information of the data table
The steps are as follows:
< p>Using PowerDesinger to produce HTML doc
PowerDesigner does not have a Database menu
powerdesigner will only show the database menu when the physical model PDM is selected. You need to double-click pdm to show the database
Dynamic data perspective query using PostgreSQL 9.3
I have a table called Product:
create table product (
ProductNumber varchar(10) ,
ProductName varchar(10),
SalesQuantity int,
Salescountry varchar(10)
); Sample value:
insert into p
PostgreSQL – How to specify different column types according to the database type of Haskell GROUNDHOG?
Using the Groundhog library in Haskell, I want to implement a column type that uses “uuid” when the backend is Postgresql, otherwise just use “varchar” for any other backends. Although this should
PostgreSQL – Docker Postgres is not running the init file in docker-entrypoint-initdb.d
Based on Docker’s Postgres documentation, I can create any *.sql file in /docker-entrypoint-initdb.d and let it run automatically.
I have init.sql contains CREATE DATABASE ronda;
In my
NOSQL – Cassandra file structure – How is the file used?
When trying to use Cassandra, I found that Cassandra will write the following files:
/…/cassandra/ commitlog/CommitLog-.log
/…/cassandra/data/Keyspace1/Standard1-1-Data.db
/…/cassandra/
Liu Wei: TIDB tool chain and ecology
This article is the content of “TiDB Tool Chain and Ecology” shared by Liu Yin, the head of PingCAP’s commercial product team, at TiDB DevCon2018 at the beginning of this year. It introduces the pe
PostgreSQL Install and create users and create a database
One. Installation You can refer to the postgresql official website installation tutorial: https://www.postgresql.org/download/linux/redhat/
Centos 6 install postgresql 10
Add RPM:
PostgreSQL – PGADMIN 4 (or DB VisualiSer) Entity Relationship
How to use pgAdmin v4 or DB Visualizer or any other open source tools to make entity relationship diagrams?
PG Administrator
pgadmin III has many interpreters, but they suggest that there sho