Not sure how to use psql

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Not sure how to use psql

Cravan

Hi all,

                I’m new to the sql language and recently learnt about psql, and have some questions about it. Firstly, after typing psql (mydatabase) in the shell, do I directly start coding? Next, when I create a table, must my headings be necessarily lowercased? Lastly, can someone help me figure out why I got this wrong?

 

Cravan

Reply | Threaded
Open this post in threaded view
|

Re: Not sure how to use psql

hubert depesz lubaczewski-2
On Wed, Jun 12, 2019 at 05:49:59PM +0800, Cravan wrote:
> I’m new to the sql language and recently learnt about psql, and have
> some questions about it. Firstly, after typing psql (mydatabase) in
> the shell, do I directly start coding? Next, when I create a table,
> must my headings be necessarily lowercased? Lastly, can someone help
> me figure out why I got this wrong?

You forgot "," at the end of previous line.

depesz


Reply | Threaded
Open this post in threaded view
|

Re: Not sure how to use psql

Pat Wright
I would suggest checking out this guide to get familiar with PSQL.   




On Wed, Jun 12, 2019 at 4:30 AM hubert depesz lubaczewski <[hidden email]> wrote:
On Wed, Jun 12, 2019 at 05:49:59PM +0800, Cravan wrote:
> I’m new to the sql language and recently learnt about psql, and have
> some questions about it. Firstly, after typing psql (mydatabase) in
> the shell, do I directly start coding? Next, when I create a table,
> must my headings be necessarily lowercased? Lastly, can someone help
> me figure out why I got this wrong?

You forgot "," at the end of previous line.

depesz