[postgis-users] Absolute Beginner

[Bob Pawley]

I know that most, if not all, on this list are interested in the geography
side of GIS.

However, I have a question on the geometry side.

I have a Delphi Canvas that I need to connect to a PostgreSQL database.

What is the minimum table structure that is needed to hold the vector
coordinates such as this path ((1,2), (3, 12)) so that it will draw the line
in Delphi?

Perhaps the Delphi knowledgeable people can let me know if the following
query is any where near correct to accomplish this action.

Thanks in advance.

Bob
     PSQLQuery1.Close;
      PSQLQuery1.SQL.Clear;
      PSQLQuery1.SQL.Add ('Select * fieldname ');
      PSQLQuery1.SQL.Add ('FROM temppath');
      PSQLQuery1.Prepare;
      PSQLQuery1.Open;
      PSQLQuery1.First ;
      i2:= PSQLQuery1.FieldByName('fieldname').AsInteger ;
      testfrm:= IntToStr(i2);