Skip to content

Instantly share code, notes, and snippets.

@matula

matula/psql-truncate.php

Created July 13, 2014 03:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matula/cdb8b7a9f9cc40461ba2 to your computer and use it in GitHub Desktop.
Save matula/cdb8b7a9f9cc40461ba2 to your computer and use it in GitHub Desktop.
Download ZIP
Truncate Table in Laravel for a table with foreign keys.
Raw
psql-truncate.php
<?php
if (DB::getName() == 'pgsql') {
DB::statement('TRUNCATE users CASCADE');
DB::statement('ALTER SEQUENCE users_id_seq RESTART WITH 1');
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment