Forums

drop only table

Hi,

Using Postgres I have an issue with a application table I need to drop.

This concerns the DB in my www.fommes.org application and within it all tables that are created under the fictionary application, ex: "fictionary_fictionaryindexpage"."table"

Other tables in my fommes project should remain intact and are not concerned.

Can you please drop only the fictionary related tables?

Thanks in advance

We do not touch users' Postgres databases. You have superuser account with all the privileges needed.

Thanks for the return. I struggle to find how I can display all tables (so I can select the exact name needed to be deleted). I naively thought tried:

  1. psql -U postgres -W or psql -U <my_user> postgres -W <my_database>

but when I then entered the my_password, it gave me an error, "error: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

  1. psql -h <host> -p <port> -U <username> -W <password> <database>

Which gave after input my_password: psql: error: FATAL: database "<my_password" does not exist

You can just use the "Start a postgres console" on the Databases tab.

I did tried it. The end result though is just blank line, starting with "postgres-#' No other output on the consol.

What you see in the console is a prompt. You can run postgres commands there.