How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL with psql command?

I am working on a marketplace, and was wondering what is the best way of handling website settings such as title, url, if its https, contact email, version, etc. I am trying to structure th...

This has me baffled, here's hoping someone can help. Query: insert into `shelter_pages` (`userid`,`relid`) select :userid, `id` from `shelter` where `stage`='egg' order by rand() limit 30 Simpl...

Lets consider that we have Person A. Person F is his father, person M is his mother, person B is his brother and person S is his son. Each person may have many relations. Thats why, we have to crea...

What is the best table structure to store dialogs between users in private messages? Each user can send personal message to many recepients. Each message has flag for sender: is message deleted or ...

MySQL specifies the row format of a table as either fixed or dynamic, depending on the column data types. If a table has a variable-length column data type, such as TEXT or VARCHAR, the row format ...

How do I check if a column exists in SQL Server 2000?

how to get table structre of a database in java?

This is a followup to: MySQL - Is it possible to get all sub-items in a hierarchy? I have an arbitrary-depth adjacency list model table (I am at the point that I can convert it into a nested set m...

Let's say I have a booking database consisting of users: user_id fname lname and their tickets ticket_id user_id flight_no and associated flights flight_no airline departure_time arrival_tim...

I am developing a web application that can support threaded comments. I need the ability to rearrange the comments based on the number of votes received. (Identical to how threaded comments work in...

How would one structure a table for an entity that can have a one to many relationship to itself? Specifically, I'm working on an app to track animal breeding. Each animal has an ID; it's also got ...

I'm looking for a pattern for performing a dynamic search on multiple tables. I have no control over the legacy (and poorly designed) database table structure. Consider a scenario similar to a re...