Thread: www.postgresql.org/idocs/index.php?tutorial-table.html
I am working my way through http://www.postgresql.org/idocs/index.php?tutorial-table.html
and I am now woundering if this:
is the correct way to make the table, weather, in a PosgreSQL database?
Yes. The CREATE message tells you that you did it correctly. Hit \d or \d weather to see the table structure. PS. You don't have to put everything on a different line, and lines that start with -- are comments. Jeff On Sunday, October 27, 2002, at 05:39 PM, Paul Ottar Tornes wrote: <excerpt><fontfamily><param>Arial</param><smaller>I am working my way through <underline><color><param>1999,1999,FFFF</param>http://www.postgresql.org/idocs/index.php?tutorial-table.html</color></underline></smaller></fontfamily> <fontfamily><param>Arial</param><smaller>and I am now woundering if this:</smaller></fontfamily> <underline><fontfamily><param>Arial</param><color><param>0000,6666,0000</param><smaller>http://80.202.101.84/index.php</smaller></color></fontfamily></underline><fontfamily><param>Arial</param><smaller> </smaller></fontfamily> <fontfamily><param>Arial</param><smaller>is the correct way to make the table, weather, in a PosgreSQL database?</smaller></fontfamily> </excerpt>======================= Jeffrey Melloy jmelloy@visualdistortion.org http://www.visualdistortion.org http://www.platformers.com Yes. The CREATE message tells you that you did it correctly. Hit \d or \d weather to see the table structure. PS. You don't have to put everything on a different line, and lines that start with -- are comments. Jeff On Sunday, October 27, 2002, at 05:39 PM, Paul Ottar Tornes wrote: > I am working my way through > http://www.postgresql.org/idocs/index.php?tutorial-table.html > and I am now woundering if this: > > http://80.202.101.84/index.php > > is the correct way to make the table, weather, in a PosgreSQL database? > ======================= Jeffrey Melloy jmelloy@visualdistortion.org http://www.visualdistortion.org http://www.platformers.com
You really shouldn't name your date column "date" as that's already used by PostgreSQL. I don't recall if it's a reserved word or not, but it's a bad practice even if it is allowed. Greg ----- Original Message ----- From: Paul Ottar Tornes To: psql Sent: Sunday, October 27, 2002 6:39 PM Subject: [GENERAL] www.postgresql.org/idocs/index.php?tutorial-table.html I am working my way through http://www.postgresql.org/idocs/index.php?tutorial-table.html and I am now woundering if this: http://80.202.101.84/index.php is the correct way to make the table, weather, in a PosgreSQL database?