Primary interactive shell for PostgreSQL.
In MS SQL Server, I create my scripts to use customizable variables: DECLARE @somevariable int SELECT @somevariable = -1 INSERT INTO …
sql postgresql variables psqlI would like to list all tables in the liferay database in my PostgreSQL install. How do I do that? …
postgresql psqlI have a postgres database with multiple schemas. When I connect to the database from a shell with psql and …
postgresql psqlI am using PostgreSQL 8.4 on Ubuntu. I have a table with columns c1 through cN. The columns are wide enough …
postgresql output-formatting psqlEntering the following command into a PostgreSQL interactive terminal results in an error: ALTER TABLE tbl_name ALTER COLUMN col_…
sql postgresql psql alter-table alter-columnI am trying to connect to a postgres database installed in a remote server using the following command: psql -h …
postgresql ubuntu psql centos7I'm trying to get psql to format nicely and am following the docs here. Right now, whenever I do a …
linux postgresql command-line psqlIs there a way to show all the content inside a table by using psql command line interface? I can …
psqlI typed psql and I get this: psql: could not connect to server: No such file or directory Is the …
postgresql psqlI have installed PostgreSQL and it is working ok. However, when I went to restore a backup I got the …
linux postgresql psql