Reputation
3,466
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
13 33
Impact
~257k people reached

11h
comment Can we export data from PostgreSQL to xlsx file?
just use JapserReports for stuff like this
Apr
29
comment Constraint on row value based on values in other rows
Exclusion constraint might work here. see postgresql.org/docs/current/static/… . Else you'll need a trigger
Apr
28
comment PostgreSQL, display role members
see also dba.stackexchange.com/questions/56096/…
Apr
25
comment Should data warehouse provide data for data composition for real time business transactions
Google Analytics is essentially a data warehouse and supports "real time" data, such as current visits
Apr
21
revised Alias Column Name
edited body; edited title
Apr
17
revised Two names for a column
added 49 characters in body
Apr
16
answered How can I represent discrete ages in a relational database?
Apr
15
revised Two names for a column
deleted 41 characters in body
Apr
15
answered Two names for a column
Apr
7
comment What is the difference between a field and a column?
Call them rows and columns here. Call them whatever you want elsewhere
Apr
5
comment Are there any schema design changes that can take a design from 4NF into a different 4NF design?
Maybe Single Table Inheritance vs Class Table Inheritance? Not sure if STI can be considered 4NF though...
Apr
4
awarded  Notable Question
Apr
4
comment Class-table inheritance without flag column
@RickJames SQL: Early 70s, OOP: mid 60s (Simula). Table Inheritance is required for concepts like the Party Model, which is highly useful
Apr
4
comment Class-table inheritance without flag column
@NicholasKyriakides you can use check constraints in other dbs, but yes, it's a problem in mysql.
Apr
3
comment Class-table inheritance without flag column
You don't need a type column. Hibernate doesn't use one, for example. You can figure out the type from the table. You're probably better off w Single Table Inheritance though, as it's faster and simpler, and works better with other tools (like Hibernate, Jackson, Spring Data)
Mar
31
comment Address database scheme - multiple links
See the "Parties and Facilities" section of Enterprise Model Patterns (Hay). You can get a free trial on safaribooksonline to read it
Mar
28
comment Is it bad practice to use separate columns for parts of date values?
@RickJames who said anything about times? Not having a date dimension in a data warehouse would be the oddest thing ever
Mar
28
revised Is it bad practice to use separate columns for parts of date values?
added 16 characters in body
Mar
28
answered Is it bad practice to use separate columns for parts of date values?
Mar
28
comment How can I edit the content of a table in the data output of a query in pgAdmin III?
You can edit data in pgAdmin III but not in the query output window. Right click table > View data. Table needs a primary key.