Re: postgres schema

[fliptop]

[reply cc:'d to the list]

Kalamity Force wrote:
> 
> i have a real postgres newbie question. can you instruct me on how to
> implement this schema. I know that I have to put this text into a file,
> but how am I executing the script?

create the db by typing at a command line:

$createdb addressbook

then you can access it by typing:

$psql addressbook

after that, you can use the \i command:

addressbook=>\i dbschema.txt

or you can cut and paste