Re: [GENERAL] list fieldnames in table? (from PHP)

2004-10-25 Thread Justin Wyer
Miles Keaton wrote: Is there a simple way to list fieldnames in a table, from PHP? When on the command-line, I just do \d tablename But how to get the fieldnames from PHP commands? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, ple

[GENERAL] (no subject)

2004-10-06 Thread Justin Wyer
subscribe ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] two digit years in inserts

2004-10-06 Thread Justin Wyer
fine before the upgrade, now however, any year before 70 gets inserted as 20xx and not 19xx. My question is between which versions did this behaviour change, and is there any way for me to force the old behaviour? Regards Justin Wyer ---(end of broad

Re: [GENERAL] two digit years in inserts

2004-10-06 Thread Justin Wyer
Tom Lane wrote: Justin Wyer <[EMAIL PROTECTED]> writes: I have this problem, I wrote a script to insert data into a table, one of the columns is a birthdate now I only have the last two year digits, and this all worked fine. Until I did a portupgrade (i am running on bsd 5.2.1 and 4