MC front end to PostgreSQL

[Pierre Sahores]

Sadhunathan Nadesan wrote:
> 
> |
> | See the "installabook.txt" for more, including explainations about the
> | need of a "primary key" to index the column "name____" and the needed
> | add of a new "serial-typed" column to the "abook" pg table, used to add
> | to each row an unicity control key...
> |
> 
> FYI, Pierre, this is what worked for me.  First I just dropped the
> data base (from the shell)
> 
>         dropdb abook
> 
> Then created a new one
> 
>         createdb abook
> 
> Then entered the interactive sql with
> 
>         psql abook
> 
> Then issued the create table command at the sql prompt.  The syntax on
> mine, version 7.1.3, is slightly different than shown in the
> installbook.txt file.  Here is what I used:
> 
>  create table abook (
>  name____  text primary key,
>  company_  text,
>  street__  text,
>  city____  text,
>  state___  text,
>  zipcode_  text,
>  telepho1  text,
>  telepho2  text,
>  mail____  text,
>  web_____  text,
>  recordid  serial not null
>  );
> 
>  this worked and gave
> 
>  NOTICE:  CREATE TABLE will create implicit sequence 'abook_recordid_seq'
>  for SERIAL column 'abook.recordid'
> 
>  NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
>  'abook_pkey' for table 'abook'
> 
>  NOTICE:  CREATE TABLE/UNIQUE will create implicit index
>  'abook_recordid_key' for table 'abook'
> 
> _______________________________________________
> metacard mailing list
> metacard at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/metacard

Allo Sadhu,

Your SQL statement is exactly the right way to use : i will update the
install docs to
avoid possibles confusions ;)
-- 
Best Regards, Pierre Sahores

Inspection académique de Seine-Saint-Denis.
Applications et bases de données WEB et VPN
Qualifier et produire l'avantage compétitif