Originally posted by anepon
Can anyone point me to a good resource, or throw a couple command lines at me to admin PGSQL through telnet (on a linux box). (i'm talkin basic stuff here, like just making the db, telling it a file full of SQL create table lines for it to act on)

$ psql test
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

test=>

There's an excellent online-book explaining it all at http://www.ca.postgresql.org/docs/aw_pgsql_book/index.html