Hey,
I'm having some trouble trying to join tables because I'm trying to join
data in a column to a column name. An example looks like this:
Table 1:
field_names(varchar 255) | field_title(varchar 255)
name_field | User Name
interest_field | User Interest
number_field | User Number
Table 2:
u
Hey all,
I need help on constructing a query with arrays that matches the arrays up
as foriegn keys to another table. For example, say that I have two tables,
owners and pets.
Owner Table
owner_id | pet_ids
1 |{1,2,3}
2 |{2,3}
Pet Table
pet_ids | Pet Type
1
I have a question about ordering by date. I have a table with two fields and
some date
Name(character varying) | Event_Date(timestamp with timezone)
A |2009-09-10 5:30:00
B |2009-09-10- 00:00:00
C
Is there a plug-in or anything that will allow me to import a whole
databases using PHPPGADMIN. I can import tables seperately but I have about
some 70 odd tables to import.
--
View this message in context:
http://www.nabble.com/Import-Using-PHPPGADMIN-tp25228684p25228684.html
Sent from the Pos
Hey all,
I've been trying to figure this problem out with just using sql but I'm not
sure how too. I have a table that holds events for each week but I only want
to select events happening for the current week(Mon-Sun). So can anyone help
me out with this just using sql? I've accomplished it sort
Tom Lane-2 wrote:
>
> BlackMage writes:
>> I am having a small issue when entering values into the interval field.
>> Say
>> I want to enter a time of 2:03, two minutes and 3 seconds. When I insert
>> that into an interval field, it comes up at 02:03:00, 2 hou
Hey,
I am having a small issue when entering values into the interval field. Say
I want to enter a time of 2:03, two minutes and 3 seconds. When I insert
that into an interval field, it comes up at 02:03:00, 2 hours, 3 minutes.
The only way I've gotten around this so far is by doing 00:02:03. But
Is there a field that can actually store time in PostgreSql. And what I mean
by time is not like time of the day, but a specific amount of time.
The application I am developing records how long it takes for a user to do a
task, say 5 minutes and 32 seconds. That time is entered into the database
