Debian and Postgres 9.0

[Fernando Duran]

Hi,

What problems are you having?

In my Debian it's just installed with the normal 'apt-get update; apt-get install postgresql*'

Then just change to the postgres user:

# su postgres -

And call the postgres command line utility:

$ psql

From here one you can for example:

create database mydb;

Etc. Some pointers once inside if you come from mysql:

SHOW TABLES = \d
SHOW DATABASES = \l
SHOW COLUMNS = \d table

to leave: \q


---------------------
Fernando Duran
http://www.fduran.com


--- On Tue, 4/19/11, William O'Higgins Witteman <william.ohiggins-H217xnMUJC0sA/PxXw9srA at public.gmane.org> wrote:

> From: William O'Higgins Witteman <william.ohiggins-H217xnMUJC0sA/PxXw9srA at public.gmane.org>
> Subject: [TLUG]: Debian and Postgres 9.0
> To: "tlug" <tlug-lxSQFCZeNF4 at public.gmane.org>
> Received: Tuesday, April 19, 2011, 8:38 AM
> Has anyone got experience with Debian
> and Postgres 9.0?  I have never
> used Postgres before, but I foolishly thought it would be
> simple.  I'm 
> just trying to get started - database server available on
> localhost and
> the ability to create databases and run SQL.
> 
> All of the tutorials seem to be subtly different, and
> Debian is
> different still, and the whole process has been quite
> frustrating.
> Anyone have some pointers?  Thanks.
> -- 
> 
> yours,
> 
> William
> 
> 
--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists