On Tue, 28 Jun 2011, Rick Genter wrote:
After issuing the \d you are still in the middle of your command. Witness
the following copy/paste of a terminal session:
Ah, so! I didn't see this.
Thank you very much,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
postgres=# drop table foo
postgres-# \d
specifically note the prompt. the -# means you're in the middle of a
command. =# means its ready for a new command.
as another example...
pierce=# create table foo (id integer);
CREATE TABLE
pierce=# drop
pierce-# table
pierce-# foo
After issuing the \d you are still in the middle of your command. Witness
the following copy/paste of a terminal session:
bash-3.2$ ./psql
Password:
psql (8.4.4)
Type "help" for help.
postgres=# create table foo (bar int);
CREATE TABLE
postgres=# drop table foo
postgres-# \d
List of relat
On Tue, 28 Jun 2011, Rick Genter wrote:
Silly question, but did you try it with a semicolon after the drop table?
Rick,
See my answer to Andy: that's incorrect syntax and psql complains.
I've noticed that if you are in the middle of a statement and issue a \
command, psql ignores the SQL
On Wed, 29 Jun 2011, Andy Firel wrote:
it might be sufficient to add a semicolon to your drop statement:
# drop table station_type;
Andy,
Actually, that's not true. On a whim I tried that and psql complained
about a syntax error at the initial 'd'.
Rich
--
Sent via pgsql-general mailing l
Hi Rich,
it might be sufficient to add a semicolon to your drop statement:
# drop table station_type;
HTH,
Andy
- Ursprüngliche Mail -
> I cannot recall issuing a DROP TABLE command from psql that did not
> work,
> but seem to have this as a new experience.
>
> When I look at the datab
Silly question, but did you try it with a semicolon after the drop table?
# drop table station_type;
I've noticed that if you are in the middle of a statement and issue a \
command, psql ignores the SQL you've typed in and just does the \ command.
On Tue, Jun 28, 2011 at 3:34 PM, Rich Shepard w
I cannot recall issuing a DROP TABLE command from psql that did not work,
but seem to have this as a new experience.
When I look at the database table list with '\d' I see
public | station_type | table| rshepard
public | station_type_statype_seq
