How to use Postgres SQL database create command?

Asked Apr 21 '14 at 00:04

Active Apr 21 '14 at 00:04

Viewed 47 times

I am running Postgresql 9.1 on ububtu I used: psql -d testdb -U postgres I can see the tables in testdb, among them tables I created earlier, however when trying: create table newtable(name VARCHAR(10)...); i get nothing. No CREATE result, and consequently do not see the new table created.

I am new to this db, would appreciate help - what is the problem here? thnx

asked Apr 21 '14 at 00:04

user3511860

1

what is the output of the create command? and what is the exact command? – Lajos Veres Apr 21 '14 at 00:07
1

Check for unterminated strings in your SQL statement and see [In psql, why do some commands have no effect?](http://stackoverflow.com/questions/12472026) – Daniel Vérité Apr 21 '14 at 01:32
Copy and paste the *exact text* from your `psql` terminal please. – Craig Ringer Apr 21 '14 at 02:45

How to use Postgres SQL database create command?

0 Answers0