Re: [SQL] (Ab)Using schemas and inheritance

2006-05-23 Thread Jim C. Nasby
Moving to -general, where it's more likely that others will have input. On Tue, May 23, 2006 at 05:16:54PM -0300, Jorge Godoy wrote: > I'm modelling an application that will have data -- financial data, human > resources, etc. -- for several hundred (even thousands) of companies. This > is for

[SQL] (Ab)Using schemas and inheritance

2006-05-23 Thread Jorge Godoy
Hi! I'm modelling an application that will have data -- financial data, human resources, etc. -- for several hundred (even thousands) of companies. This is for an accounting office. I could put some kind of "company_id" column in all of my tables to separate data in a more standard way, I c

Re: [SQL] hi can u give solution to this query

2006-05-23 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P.Sent: 23 May 2006 13:41To: pgsql-sql@postgresql.orgSubject: [SQL] hi can u give solution to this query Hi sir…    If u don’t mind can u reply for this  question   This is on

Re: [SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Patrick JACQUOT
Penchalaiah P. wrote: I created one table in pgAdmin tool but when I am executing query it is giving error…. CREATE TABLE "ADV" ( "T-Section_Id" varchar(10) NOT NULL, "CDA_No" varchar(7) NOT NULL, "Imp_Schedule_Id" int4 NOT NULL, "Sanction_No" varchar(20) NOT NULL, "Sanction_Date" date N

[SQL] hi can u give solution to this query

2006-05-23 Thread Penchalaiah P.
Hi sir…    If u don’t mind can u reply for this  question   This is one table… it has one primary key…….so I can insert the values from  data edit…   1)…CREATE TABLE "ADV" (   "T-Section_Id" varchar(10) NOT NULL,   "CDA_No" varchar(7) NOT NULL,   "Imp_Schedule_Id" int4 NOT NULL,

Re: [SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Dave Page
  From: Penchalaiah P. [mailto:[EMAIL PROTECTED] Sent: 23 May 2006 13:18To: Dave PageSubject: RE: [SQL] some error when executing query in pgAdmin tool Hi sir…   I tried like that also … but I am getting same error……I tried like these……   1).Select * fr

Re: [SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Dave Page
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Penchalaiah P.Sent: 23 May 2006 13:11To: pgsql-sql@postgresql.orgSubject: [SQL] some error when executing query in pgAdmin tool   I created one table in pgAdmin tool but when I am executing query i

[SQL] some error when executing query in pgAdmin tool

2006-05-23 Thread Penchalaiah P.
  I created one table in pgAdmin tool but when I am executing query it is giving error….   CREATE TABLE "ADV" (   "T-Section_Id" varchar(10) NOT NULL,   "CDA_No" varchar(7) NOT NULL,   "Imp_Schedule_Id" int4 NOT NULL,   "Sanction_No" varchar(20) NOT NULL,   "Sanction_Date" date NOT