Copy a postgres database without LOCK permissions
ERROR: permission denied for relation sl_node This is your real problem. Make sure the user bob has SELECT privilege for _replication.sl_node. Is that by any chance a Slony system table or something?
database
Use cases for updateOne over findOneAndUpdate in MongoDB [duplicate]
I think that findOneAndUpdate carries out an atomic operation, so I’m assuming that updateOne does not. Why are you assuming that? findOneAndUpdate returns a document whereas updateOne does not (it just returns the _id if it has created a new document). I think that’s the main difference. So the use case of updateOne is when … Read more
How to create an empty SQLite db with command?
Use the VACUUM command to create a valid empty SQLite database file, including the root database page and the database header. sqlite3 file.db “VACUUM;”
Automatically populate a timestamp field in PostgreSQL when a new row is inserted
To populate the column during insert, use a DEFAULT value: CREATE TABLE users ( id serial not null, firstname varchar(100), middlename varchar(100), lastname varchar(100), email varchar(200), timestamp timestamp default current_timestamp ) Note that the value for that column can explicitly be overwritten by supplying a value in the INSERT statement. If you want to prevent … Read more
PostgreSQL: Export the schema of a database
You should take a look at pg_dump: pg_dump –schema-only databasename Will dump only the schema to stdout as .sql. For windows, you’ll probably want to call pg_dump.exe. I don’t have access to a Windows machine but I’m pretty sure from memory that’s the command. See if the help works for you too.
Create database from command line in PostgreSQL
Change the user to postgres : su – postgres Create User for Postgres (in the shell and NOT with psql) $ createuser testuser Create Database (same) $ createdb testdb Acces the postgres Shell psql ( enter the password for postgressql) Provide the privileges to the postgres user $ alter user testuser with encrypted password ‘qwerty’; … Read more
PostgreSQL: Export database to .sql file
pg_dump defaults to plain SQL export. both data and structure. open command prompt and run pg_dump -U username -h localhost databasename >> sqlfile.sql Above command is preferable as most of the times there will be an error which will be something like – …FATAL: Peer authentication failed for user …
How to list all tables in psql?
If you wish to list all tables, you must use: \dt *.* to indicate that you want all tables in all schemas. This will include tables in pg_catalog, the system tables, and those in information_schema. There’s no built-in way to say “all tables in all user-defined schemas”; you can, however, set your search_path to a … Read more
How to show tables in PostgreSQL?
From the psql command line interface, First, choose your database \c database_name Then, this shows all tables in the current schema: \dt Programmatically (or from the psql interface too, of course): SELECT * FROM pg_catalog.pg_tables; The system tables live in the pg_catalog database.
Where can I get postal codes for all countries?
My guess is that your lost friend is GeoNames.