Skip to content

Instantly share code, notes, and snippets.

@ruiteix

ruiteix/postgres_unlogged_tables.sql

Created May 27, 2019 08:19
Show Gist options
  • Save ruiteix/45b4cd22f373eaeac4d58a7176299760 to your computer and use it in GitHub Desktop.
Save ruiteix/45b4cd22f373eaeac4d58a7176299760 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres unlogged tables
Raw
postgres_unlogged_tables.sql
-- creation table unlogged
CREATE UNLOGGED TABLE name (
-- ...
);
-- convertir une table
ALTER TABLE name SET UNLOGGED;
-- Lister les tables unlogged
SELECT relname FROM pg_class WHERE relpersistence = 'u';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment